How to Display Automatically Updated Excel Data on a Non-Interactive Screen
Question details
A company needs to display refreshed Excel work-list data on a local network screen without requiring an extra Office license for the display computer, ensuring the data appears as a simple, non-interactive list.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Setting up a digital signage or display screen to show updated work lists or data tables over a local network without needing user interaction or dedicated software licenses on the display machine.
- Observed behavior
- The goal is to maintain an updated visual output of a spreadsheet as a simple list or report, avoiding the display of a full, interactive spreadsheet interface.
Ensure the primary host computer running the original Excel file has a valid license and maintains a stable local network connection to a shared folder that the display screen can access.
Export Data to PDF Using VBA or Scheduled Tasks
Exporting the worksheet to a PDF allows the non-licensed display computer to view the data seamlessly using a free PDF reader or web browser.
By setting up an automated process to generate a PDF, you decouple the data processing from the display system. This completely eliminates the need for an Office license on the display monitor while keeping the visual output clean and non-interactive.
On the licensed computer, open the Excel file and format your worksheet to look exactly how it should appear on the screen. Hide gridlines, adjust column widths, and set the Print Area under the 'Page Layout' tab.
Press ALT + F11 to open the VBA editor. Write a simple VBA macro using the 'ExportAsFixedFormat' method to save the specific worksheet as a PDF file to a shared network drive.
Use the 'Application.OnTime' function in VBA, or write a PowerShell script triggered by Windows Task Scheduler, to run the PDF export macro at regular intervals (e.g., every 15 minutes).
On the display computer, navigate to the shared network drive and open the generated PDF using a web browser like Chrome or Edge in full-screen presentation mode (F11).
Install an auto-refresh browser extension on the display computer's browser, configuring it to reload the PDF tab automatically at an interval slightly longer than your export schedule to ensure it always shows the latest data.
Use Web-Based Dashboards for Real-Time Requirements
If near real-time updates are critical, publishing the Excel data to a web-based dashboard is more efficient than continuous file exports.
Automate Excel to PDF Exports with WPS Spreadsheet
WPS Office provides a lightweight, highly compatible spreadsheet tool that supports VBA macros and seamless PDF exporting, making it easy to set up automated display screens without expensive software licenses.
- 1. Open data file in WPS Office: Launch WPS Spreadsheet on your main workstation and open your source data file.
- 2. Format for screen display: Format the data into a clean, easy-to-read list and hide any unnecessary UI elements or gridlines from the View tab.
- 3. Implement automation: Go to the 'Developer' tab to insert your PDF-export VBA macro, or use 'Menu' > 'Export to PDF' to verify the output manually.
- 4. Save to shared network: Direct the PDF save path in your script to a local network drive accessible by your display monitor for seamless viewing.
Frequently Asked Questions
Can I display the Excel file directly without installing Office on the display PC?
Yes, you could use a free viewer like Excel for the Web or WPS Office Free on the display PC. However, exporting to a non-interactive format like PDF is generally better for unattended screens because it prevents accidental edits and hides spreadsheet toolbars.
How do I make the PDF auto-refresh on the display screen?
The easiest way is to open the PDF file in a standard web browser (like Google Chrome or Microsoft Edge) rather than a dedicated PDF reader, and install a free auto-refresh extension. You can configure the extension to reload the page every few minutes to fetch the newly generated PDF file.
Will VBA macros run to update the PDF if the Excel file is closed?
No, VBA macros require the Excel application to be open and running to execute. For background automation without keeping the file open on your desktop, you should consider using Power Automate, Python, or a scheduled PowerShell script to interact with the file.
