Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable pivottable refresh message
Hi, I have several excel pivottables which refresh hourly linked to a access database, the workbook then saves and the whole process repeat until... When the date passes midnight a message will appear when the table refresh saying that the pivottable has change and to press ok. This th 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 thi particular prompt ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivottable refresh in shared workbook | Excel Discussion (Misc queries) | |||
How to refresh a Scenario PivotTable Report? | Excel Discussion (Misc queries) | |||
Refresh and PivotTable with Analysis Services | Excel Worksheet Functions | |||
Locking column width - upon refresh of PivotTable | Setting up and Configuration of Excel | |||
Retain PivotTable formatting after "Refresh Data" | Excel Discussion (Misc queries) |