Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 347
Default skip automatic update question to excel

I have embedded external data in my datasheet, and excel asks me if I want to
automatically update the information. How can I set Excel to skip the
question and always update on this file.
  #2   Report Post  
Posted to microsoft.public.excel.programming
JMB JMB is offline
external usenet poster
 
Posts: 2,062
Default skip automatic update question to excel

Tools/Options/Edit - uncheck ask to update automatic links. Of course, this
will be applied to all of your workbooks as it is an application setting.

"George" wrote:

I have embedded external data in my datasheet, and excel asks me if I want to
automatically update the information. How can I set Excel to skip the
question and always update on this file.

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 can i set up an automatic "date update" in excel? Litzyam New Users to Excel 3 April 5th 23 02:55 PM
How to skip the enable update confirmation? Eric Excel Discussion (Misc queries) 1 May 24th 10 10:51 AM
Automatic update of spreadsheet & automatic update between workboo Losva Excel Worksheet Functions 6 September 12th 08 03:22 PM
Automatic Update from Access to EXcel Jay Excel Discussion (Misc queries) 0 February 11th 06 07:01 PM
Automatic update of list in Excel Swampy Excel Worksheet Functions 0 August 3rd 05 04:31 PM


All times are GMT +1. The time now is 12:40 PM.

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

About Us

"It's about Microsoft Excel"