Enable Automatic Refresh

  • Thread starter Thread starter jbim
  • Start date Start date
J

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.
 
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.
 
You could try and see if this helps:

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

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