Hi all

I have set up queries in Excel using:
Data-Import External Data-New Database Query

After I saved the workbook with the queries, I close it and re-open the
workbook. That's when a prompt keeps popping up every time I re-open the
workbook asking me if I want to do a query refresh. It gave me two options:
[Enable automatic refresh] [Disable automatic refresh]

I want it to retrieve the data every time I open the workbook, but is there
any way to disable this pop up prompt by changing certain setting or is there
a programmatic way to disable it at run time? Thanks for sharing your
suggestions.

Ben


--