How to Display Live Excel Data on an Intranet Web Page
Question details
The user needs to display a single worksheet of live data from a multi-sheet Excel workbook on an internal web page or factory screen without relying on remote-desktop control.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Setting up a factory screen or internal dashboard to display specific spreadsheet data.
- Observed behavior
- The user is looking for a web-based embedding or publishing solution to replace manual remote-desktop Excel displays.
Ensure that your workbook is saved to a cloud location such as OneDrive or SharePoint, and that the target audience or display device has the necessary viewing permissions.
Embed the Worksheet via Excel for the Web
The most reliable way to display a specific worksheet on an intranet page is by generating an HTML embed code directly through Excel for the Web.
By using Microsoft's built-in web embedding feature, you can isolate a specific worksheet or cell range to be displayed on your internal website. This avoids the need to keep the desktop application open on a remote machine.
Save your Excel workbook to OneDrive or SharePoint and open it in your browser using Excel for the Web.
Click on 'File' in the top ribbon, select 'Share', and then choose 'Embed'.
In the Embed dialog box, choose the specific worksheet you want to display under the 'What to show' dropdown menu.
Copy the generated HTML iframe code and paste it into the source code of your intranet web page.
Publish a Live Dashboard using Power BI
For advanced factory screens requiring automated, real-time visual updates, connect your Excel workbook to Power BI and embed the report.
Use a VBA Macro to Auto-Publish as HTML
If cloud hosting is not an option, you can use a VBA macro to automatically save the required worksheet as a web page format on your local network.
Manage and Share Spreadsheets Easily with WPS Office
While integrating with Microsoft-specific intranet tools like SharePoint might require Excel, WPS Office provides a lightweight, highly compatible alternative for handling all your daily spreadsheet tasks. You can seamlessly view, edit, and share workbooks with full Microsoft format compatibility.
- 1. Download and Install: Visit the official WPS website to download and install the free WPS Office suite on your device.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing .xlsx or .xls files without losing any formatting or data.
- 3. Share with Your Team: Use the built-in 'Share' button to generate a secure link, allowing colleagues to view or edit the live document.
Frequently Asked Questions
Can I embed only a specific range of cells instead of the whole worksheet?
Yes. When generating the embed code in Excel for the Web, you can choose 'Item' or 'Range' in the embed options and type in the specific cell references (e.g., A1:G10) to restrict the visible data.
Will the embedded Excel web page update in true real-time?
The embedded workbook will display the latest saved data whenever the intranet page is reloaded. For continuous live streaming without manual page refreshes, you would need to implement an auto-refresh script on your intranet webpage or use dedicated dashboard tools like Power BI.
Do intranet viewers need a Microsoft account to see the embedded spreadsheet?
It depends on the sharing permissions set on the file. If you create an 'Anyone with the link' sharing link before generating the embed code, viewers will not need to sign in. If the file is restricted to people in your organization, viewers will be prompted to log in.
