Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default 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
  #2   Report Post  
Senior Member
 
Location: Hyderabad
Posts: 237
Thumbs up

Quote:
Originally Posted by Eric View Post
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
if you are using excel 2007, go to excel options, Advanced, General - uncheck to ask to update automate links.

all the best
__________________
Thanks
Bala
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to disable the pop up for enable auto update? Eric Excel Discussion (Misc queries) 2 April 16th 10 05:12 AM
How to enable macro and updated link without confirmation? Eric Excel Discussion (Misc queries) 1 April 14th 09 06:56 AM
Enable Automatic Update for Web Query Terri Excel Worksheet Functions 0 May 5th 05 11:56 PM
Enable Automatic Update for Web Query Terri Excel Worksheet Functions 0 May 5th 05 11:56 PM
Getting rid of confirmation boxes DandruffKid New Users to Excel 2 March 28th 05 11:05 AM


All times are GMT +1. The time now is 09:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"