ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel is paranoid, and I'm an annoyed nerd. (https://www.excelbanter.com/excel-discussion-misc-queries/1181-excel-paranoid-im-annoyed-nerd.html)

John O'Flaherty

Excel is paranoid, and I'm an annoyed nerd.
 
I have a spreadsheet with a web data import query that is set to
automatically refresh every 30 minutes. Whenever I open the spreadsheet,
I get a dialog box "Query Refresh" that tells me my workbook contains
queries to external data that refresh automatically... etc., etc.
I have to click "Enable automatic refresh" to get rid of the dialog box.
I want to get rid of the warning box, and just have it run after being
started.

Looking through the help files, the only hint I got was to go to
Tools-Options-Edit, and there I unchecked 'ask to update automatic
links'. That doesn't change anything. I have security settings set to
the lowest possible option (I don't use anyone else's spreadsheets).

How can I make my spreadsheet trust itself?


All times are GMT +1. The time now is 04:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com