PDA

View Full Version : Solved: Disable Auto Refresh on Open



SherryO
07-17-2006, 08:00 AM
I have a xlt with two pivot tables in it that prompts the user for enable or disable automatic refresh upon open. How do I make it so it doesn't prompt and set it to disable?
thanks

austenr
07-17-2006, 09:07 AM
I would assume that is you do not check this box it will not refresh on open.

If you want Microsoft Excel to refresh the report automatically when you open the workbook, set this option.
http://vbaexpress.com/forum/mk:@msitstore:msohlp11.chm::/html/bluedrop.gifHow? (mk:@MSITStore:C:\Program%20Files\Microsoft%20Office\OFFICE11\1033\xlmain11 .chm::/html/xlhowUpdateDataInAPivotTable1.htm#)

On the PivotTable toolbar, click PivotTable or PivotChart, and then click Table Options or Options.
Select the Refresh on open check box.
HTH

SherryO
07-17-2006, 09:27 AM
I thought so too, but it still prompts to enable / disable auto refresh. Am I missing something?

SherryO
08-01-2006, 06:19 AM
I missed a pivot table.