Hello All,

I am using Excel 2002 and I created a link to a SQL server database by
selecting:

Data->Import External Data->New Database Query

from the menu.

In the Data Range Parameters I clicked the box that said 'Refresh data on
file open' which I do want to do.
Then when every time I opened the file a message would pop up saying that it
was going to connect to the datasource and update. It would allow me to click
either Enable Refresh or Disable Refresh (the buttons may have been labelled
differently). There was also a check box that said "Enable automatic refresh
permenantly" or something similar.

Well I accidentally clicked that box when I didn't want to. Now I can't find
where to turn it off. I have another excel file that I want to open, but I
don't want to refresh the data!

I have searched through the help and the support.microsoft.com site and
can't find anything.

Any help would be greatly appreciated.

-Sam