The 'enable automatic refresh' message can supressed by making registry
changes.

http://support.microsoft.com/kb/248204




"smonczka" wrote:

I have a pivot table that pulls from an outside data source, when you
open up the file it always asks you if you want to "ENABLE AUTOMATIC
REFRESH". Is there any way to code this so it will automatically
refresh without asking the user? Maybe by setting up an on open macro
that would select the option to refresh for the user.

Thanks,
Steve