Enable Pivot Table Auto Refresh after being disabled

Giganews Newsgroups
Subject: Enable Pivot Table Auto Refresh after being disabled
Posted by:  Steve LaFever (Steve.LaFev…@wichita.edu)
Date: Fri, 10 Oct 2003

I believe I may have accidentally clicked on the box
to "Enable Automatic Query refresh for all workbooks and
do not show this box again".  How do you manage to
recreate this option?  I have some very complicated
workbooks with numerous worksheets that link to each other
and therefore, I have set up auto refresh queries to
simplify the process.  However, it now auto refreshes and
as a result I am unable to open prior workbooks to reprint
previous data as it autorefreshes for the current data.
Any ideas?

Replies