'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Display a Live Excel Workbook on Remote Office Screens
Question details
The user needs to display a frequently updated Excel workbook on various screens across an office and warehouse while it is actively being edited by a team member.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Broadcasting live data updates to multiple remote displays in a professional environment.
- Observed behavior
- The goal is to ensure remote screens reflect the latest workbook changes in real-time or near real-time as edits are made in the main office.
Ensure the Excel workbook is saved to a cloud storage service like OneDrive or SharePoint, and check that all remote display screens have a stable internet connection and a compatible web browser.
Use Excel for the Web via OneDrive or SharePoint
By hosting the file in the cloud, you can open the workbook in a web browser on multiple screens, utilizing Excel's co-authoring feature to show live updates.
This is the most straightforward method. Cloud storage allows the file to act as a live web page. When changes are made by the main editor, the web versions displayed on remote monitors pull those updates automatically through the co-authoring sync mechanism.
Upload your Excel workbook to a cloud service such as Microsoft OneDrive or SharePoint.
On your remote office or warehouse screens, open a web browser and navigate to the shared link of the workbook.
As the team member edits the file in the office via the desktop app or web version, the co-authoring feature will automatically sync and display the newest changes on all connected screens.
Embed the Workbook in a Custom Web Dashboard
Useful if you want to display the spreadsheet alongside other company information on an intranet page.
Utilize Dedicated Digital Signage Software
The best approach for reliable multi-screen control, remote monitoring, and automated content rotation.
Collaborate and Share Spreadsheets Live with WPS Office
WPS Office provides powerful cloud collaboration tools, allowing you to easily host, edit, and share spreadsheets in real-time. With WPS Cloud, remote screens can display up-to-date information instantly as your team works.
- 1. Install WPS Office: Download and install WPS Office, then sign in to your WPS account.
- 2. Save to Cloud: Save your spreadsheet to WPS Cloud to enable online collaboration and live syncing.
- 3. Share and Display: Generate a sharing link and open it on your remote screens' web browsers to display live updates without needing additional software on the displays.
Frequently Asked Questions
Will the remote screens refresh automatically when the Excel file is updated?
Yes, if you use Excel for the Web or WPS Cloud with co-authoring enabled, changes made by the editor sync automatically. However, there might be a slight delay depending on network speeds, so it is recommended to test the refresh timing on your specific setup.
Do I need an Excel license for every remote screen?
No. If you share the workbook via a view-only web link using OneDrive, SharePoint, or WPS Cloud, you can display it on multiple remote browsers entirely for free without needing separate software licenses for the display machines.
How can I prevent the screen from falling asleep while displaying the workbook?
You will need to adjust the power and sleep settings on the operating system of the device connected to the remote screen, setting it to 'Never sleep'. Alternatively, using professional digital signage software can manage screen wake states automatically.
