Hi,
I have several excel pivottables which refresh hourly linked to an access database, the workbook then saves and the whole process repeats until...
When the date passes midnight a message will appear when the tables refresh saying that the pivottable has change and to press ok. This the stops all macros running till it is pressed.
How can this prompt be disabled?
I've tried application.displayalerts false but it has no effect on this particular prompt.
I have several excel pivottables which refresh hourly linked to an access database, the workbook then saves and the whole process repeats until...
When the date passes midnight a message will appear when the tables refresh saying that the pivottable has change and to press ok. This the stops all macros running till it is pressed.
How can this prompt be disabled?
I've tried application.displayalerts false but it has no effect on this particular prompt.