enable automatic refresh
Its a financial worksheet that pulls data from other internet sites.
When it opens it displays the following message and I always click the
enable button. I'd prefer it was always enabled.
Query Refresh
This workbook contains queries to external data that refresh
automatically
queries are used to import external data into excel, but harmful
queries can be used to access confidential information or write
information back to a database
if you trust the source of this workbook, you can enable automatic
query refresh...
Chris
|