Solved: Disable Auto Refresh on Open

[SherryO]

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]

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.
How?

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

HTH

[SherryO]

I thought so too, but it still prompts to enable / disable auto refresh. Am I missing something?

[SherryO]

I missed a pivot table.