How about:
In the ThisWorkbook code section:
And in a standard module:
Private Sub Workbook_Open() PeriodicUpdate End Sub
The .calculate should envoke a refresh. Please reply with results as this is untested.Sub PeriodicUpdate() With Application .Calculate .OnTime Now + TimeValue("00:05:00"), "PeriodicUpdate" End With End Sub
Perhaps it was the Noid who should have avoided me...
If you are satisfied with my solution click the small star icon on the left. Thanks
1. Make a copy of your workbook and run the following code on your copy (just in case)
2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
3. Paste the code from above into the empty white space. Close the VBE.
4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".
I just tried it and received a "Compile Error"
Compile Error.jpg
Handy things to keep in mind:
Click *, if my suggestion has helped you
If your problem is solved, then please mark the thread as SOLVED
Sharing is Caring .... spread the knowledge
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks