Enable Automatic Refresh

[jbim]

Hi, I'm using Excel 2003 and have ran into a issue I can't seem to
resolve. I have a sheet that gets external data from an Access
Database when I open the worksheet. The issue is I always get a pop
up with the following message, This Workbook contains queries to
external data that refresh automatically" I have two choices,
"Enable Automatic Refresh" or "Disable Automatic Refresh". I would
like it to automatically refresh everytime I open the file, but
everytime I open I get the same prompt. How can I shut off the prompt
and just refresh automatically? Thanks.

 

[RagDyeR]

You could try and see if this helps:

<Tools> <Options> <Edit> tab,
And *Uncheck*
"Ask To Update Auto Links".
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hi, I'm using Excel 2003 and have ran into a issue I can't seem to
resolve. I have a sheet that gets external data from an Access
Database when I open the worksheet. The issue is I always get a pop
up with the following message, This Workbook contains queries to
external data that refresh automatically" I have two choices,
"Enable Automatic Refresh" or "Disable Automatic Refresh". I would
like it to automatically refresh everytime I open the file, but
everytime I open I get the same prompt. How can I shut off the prompt
and just refresh automatically? Thanks.

 

[jbim]

You could try and see if this helps:

<Tools> <Options> <Edit> tab,
And *Uncheck*
"Ask To Update Auto Links".

Tried that, doesn't work. I also have macro security set to low.
Thanks

 

[jbim]

Tried that, doesn't work. I also have macro security set to low.
Thanks

I guess the only saying applies here, if you want it done do it
yourself. Just kidding, thanks for the help but I found my solution
at http://support.microsoft.com/kb/248204

This fix also applies to Office 2003