ExcelBanter - How to skip the enable update confirmation?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to skip the enable update confirmation? (https://www.excelbanter.com/excel-discussion-misc-queries/264351-how-skip-enable-update-confirmation.html)

Eric

How to skip the enable update confirmation?

I have imported a web link to be updated once this file is opened, it
requests for enable update confirmation whenever it opens.
Does anyone have any suggestions on how to skip this confirmation?
Thanks in advance for any suggestions
Eric

bala_vb

Quote:

Originally Posted by Eric (Post 955581)

if you are using excel 2007, go to excel options, Advanced, General - uncheck to ask to update automate links.

all the best

All times are GMT +1. The time now is 01:59 PM.