bala_vb

Senior Member

Location: Hyderabad

Posts: 237

Quote:

Originally Posted by Eric

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 With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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:17 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us