[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 719
  • Last Modified:

Excel Auto Refresh Standalone

Hi all, trust you are keeping well!

Just stumped on this one.

Client wants a shared excel workbook to be displayed on a big screen down in their factory. The spreadsheet will be updated by the admin girls. The factory PC / Big screen needs to displayed the updated spreadsheet automatically and refresh every ten minutes.

Can this be done - using VBA/Macros or is there a better way?

Thanks
Sean
0
SeanNij
Asked:
SeanNij
3 Solutions
 
Rgonzo1971Commented:
Hi,

Go to Review / Changes / Share Workbook / Advanced
Update Changes Automatically Every

Change to 10 Minutes

Click OK

Regards
0
 
Rob HensonIT & Database AssistantCommented:
As soon as you mention the word Shared in Excel, the sirens start ringing. The Shared Workbook function in Excel is notoriously unreliable causing various issues ranging from File Size bloating to outright corruption.

The consensus of opinion around various EE threads is not to use the Shared Workbook function.

If the display version is purely for Display it doesn't need to have Write Access so therefore can be Read Only. As such there could be a routine on the machine displaying that file to close it and re-open the saved copy every 10 minutes. That would however be reliant on the Admin team ensuring they save changes as they are made so that the factory display version shows the latest version.

Will the Admin team need concurrent access, ie more than one person at a time?

We don't know the full scenario but do each of the Admin team have their own section to update?

How about this for an alternative scenario? Each Admin team member has their own workbook to update, these individual workbooks are linked to a master workbook which is then displayed in factory. Routine runs on Display machine to update the links every 10 minutes.

Thanks
Rob H
0
 
regmigrantCommented:
just my five cents:-

in addition to Rob's comments above I would guess that they don't want to see the actual spread sheet data - since no matter how large the screen you wont be able to see/interested in numbers.

A separate 'dashboard' style workbook charting the information in the shared workbook would not need write access and would present data in a more visible and useful manner. The update points Rob makes still stand but at least this would de-couple the factory display from the update workbook
0
 
SeanNijAuthor Commented:
Guys, I've been struggling to award the points, as all the effort you presented is worth more then 500 "points".
That been said, I have split 500 equally between the three of you.
My reason, just cause that's as fair as I can be.
Rgonzo1971 - answered the question as if I asked it without thinking laterally - so he has to get the points, however, Rob and Regmigrant, you both have answered it laterally.
You have all given me more then I bargained for! Thank you.
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now