M365 Excel – Live KPI dashboards on digital signage

The Valotalive M365 Excel App connects directly with Microsoft 365, displaying live Excel data and charts on your digital signage screens. Data updates every 15 minutes, and charts are displayed at their original size.

App main features

✔ Secure authentication with Entra ID credentials

✔ Display Excel charts, table data, or both

✔ Specify the exact sheet and data range to show

✔ Control how often data refreshes with the update interval

Example of the Valotalive Excel app for Digital Signage

Supported formatting

The app supports the following Excel formatting features:

Conditional formatting – Format cells based on their values to reveal trends and patterns, for example color-coding temperature figures
Fill color – Change the background color of cells, rows or columns
Color scales – Apply gradient colors to a range of cells to represent data distribution visually
Table format – Convert cell ranges into styled Excel tables with built-in filtering and sorting
Font color – Customize the text color within cells
Border color – Change cell border colors to organize and distinguish data
Cell style – Apply predefined formatting for consistent visual presentation

Prerequisites

An active Microsoft 365 account with access to Excel files stored in OneDrive or SharePoint

How to activate the M365 Excel App

The easiest way to activate the app is from the Valotalive Dashboard. Click the M365 Excel App icon and follow the prompts.

For a full walkthrough of the first steps, see: Valotalive content App – Activate and go live

Configuration Settings

Theme
The selected theme determines the background color. All other colors are sourced from the original Excel file.
Authorize with OAuth2
Authenticate Valotalive with your Microsoft account using OAuth2.

If you are prompted about needing admin approval, e.g. the authorization stops to ask "Need admin approval?"see:
- Microsoft integrations – Need admin approval
- MS Entra ID integrations & Valotalive on the Enterprise Applications directory
Choose your Excel file
After authentication, use the file picker to select the Excel file you want to display.
What to visualize
Choose what content the app displays:
- Show only cell data – Displays a scrolling view of your table data. The Duration setting controls how long it takes to scroll through the data once.
- Show only graphs – Automatically displays all charts found in the Excel file.
- Show both graphs and cell data – Displays charts and table data together.
Data range from the sheet
Specify the data range you want to display. The default is A1:Z24 — 24 rows across columns A to Z on the first visible sheet.

Use A1 notation: [SheetName]![top left corner]:[bottom right corner]. Row numbers are mandatory.

Example: to show cells A1 to C10 on a sheet named Sheet1, enter Sheet1!A1:C10

⚠️ Important:
- All column letters must be in capitals
- The sheet name in the settings must exactly match the name in your Excel file. For example, if your sheet is named Tabelle1, use Tabelle1!A1:C10 — not Sheet1!A1:C10
Cell border color
If your theme has a light background, use a darker border color for better visibility.
Duration
Set how many seconds each slide or data view is displayed on screen.