I guess we'll need to have a little more insight into the type of information, and where it originates, stored in the Excel sheet, to help you further. (With a +1 to shades' reply )
-Ath
Ok, here's the more detailed rundown:
The purpose of this is for people working in our production environment to easily be able to see which products/orders have been approved and released for them to begin work on.
The Source file is located on our fileserver. It is an Excel file containing a table with 5 columns: Date of approval; Product#; Product Name; Initials of who approved; Time of approval.
On the production floor, I set up a wall-mounted screen with an Intel Compute Stick. This has a locally stored Excel file, ("Dashboard"), which contains only a query to the table in the Source file. The query is set up to refresh every minute. This seemed to be the best way, using Excel, to have a near-realtime view of what was being approved, without having the "Locked for editing" message and without relying on a "cloud", internet-based solution e.g. Google Sheets. There is a mouse mounted to the wall next to the screen, so workers can scroll up and down the spreadsheet to see what has been approved.
The closest analogy I've come up with for this is an airport Departures/Arrival screen: Data gets updated by someone, and the screen shows the changes as they happen.
I used Excel because A) we have it installed already and B) People are familiar with it. It seemed like it would be the easiest way to do this at the time. I'd be happy to hear the alternatives!
Let me know if more detail is needed.