Problem using OnTime function within Excel 2007 macro
Posted on 2010-09-08
I am trying to create a macro for a workbook we have created that will simply refresh the data on the workbook once it is opened every 5 minutes.
This is what I have written into the macro:
' AutoRefresh Macro
Application.OnTime Now + TimeValue("00:05:00"), "AutoRefresh"
It is a pretty simple macro, but it isn't working.
The way I have tested it is that I have the workbook opened on multiple PCs on the network. I then have one user update the data on her PC. 5 minutes later or more, I check the other PCs that have the workbook open. None of the updated data shows up.
Kindly please advise.