#1   Report Post  
Old May 28th 06, 09:47 AM posted to microsoft.public.excel.misc
WhytheQ
 
Posts: n/a
Default Updating Links

(using Excel2003 and XP)

i have a wkbookA that has formulas in it linked to cells in wkbookB and

wkbookC
when book A is opened the warning about "Do you want to update links
blah blah...." appears even though I have gone into EditLinks and on
2003 there is an option to automatically update links and do not warn
user, which I have checked, I've checked this box for all links but
still when the user opens the book the message appears.


would the problem be that i have an autoopen routine in the workbook?


any help greatly appreciated
jason


  #2   Report Post  
Old May 28th 06, 12:17 PM posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Updating Links

There's another setting that you should toggle:

Tools|Options|edit tab|uncheck "Ask to update automatic links"

If you're sharing the workbook with others and expect the same behavior, you'll
want to know that this is a user-by-user setting. Each user would have to
toggle this off. And it affects all workbooks opened by the user, too.

WhytheQ wrote:

(using Excel2003 and XP)

i have a wkbookA that has formulas in it linked to cells in wkbookB and

wkbookC
when book A is opened the warning about "Do you want to update links
blah blah...." appears even though I have gone into EditLinks and on
2003 there is an option to automatically update links and do not warn
user, which I have checked, I've checked this box for all links but
still when the user opens the book the message appears.

would the problem be that i have an autoopen routine in the workbook?

any help greatly appreciated
jason


--

Dave Peterson
  #3   Report Post  
Old May 29th 06, 05:40 PM posted to microsoft.public.excel.misc
WhytheQ
 
Posts: n/a
Default Updating Links

cheers Dave.

Jason

  #4   Report Post  
Old May 30th 06, 08:52 AM posted to microsoft.public.excel.misc
WhytheQ
 
Posts: n/a
Default Updating Links

Dave,
That worked fine.
Also with 2003 I get an annoying little window opening up on start-up
called "Getting Started" : couldn't see any setting in ToolsOptions
for this one -any ideas?

Thanks again
J

  #5   Report Post  
Old May 30th 06, 12:33 PM posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Updating Links

Tools|Options|view tab|uncheck startup task pane

Is where I'd start.

WhytheQ wrote:

Dave,
That worked fine.
Also with 2003 I get an annoying little window opening up on start-up
called "Getting Started" : couldn't see any setting in ToolsOptions
for this one -any ideas?

Thanks again
J


--

Dave Peterson


  #6   Report Post  
Old May 31st 06, 08:41 AM posted to microsoft.public.excel.misc
WhytheQ
 
Posts: n/a
Default Updating Links

once again I bow down to your encyclopeidic knowledge of Excel Dave!

also matey: I'm presently trying to get my head around Class Modules &
try to work out how to apply them - can you point me in the direction
of some good internet resources/examples.

thanks again
J


Dave Peterson wrote:
Tools|Options|view tab|uncheck startup task pane

Is where I'd start.

WhytheQ wrote:

Dave,
That worked fine.
Also with 2003 I get an annoying little window opening up on start-up
called "Getting Started" : couldn't see any setting in ToolsOptions
for this one -any ideas?

Thanks again
J


--

Dave Peterson


  #7   Report Post  
Old May 31st 06, 01:51 PM posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Updating Links

Debra Dalgleish has a list of books at her site:
http://www.contextures.com/xlbooks.html

You may want to look at:

Professional Excel Development
By Stephen Bullen, Rob Bovey, John Green


WhytheQ wrote:

once again I bow down to your encyclopeidic knowledge of Excel Dave!

also matey: I'm presently trying to get my head around Class Modules &
try to work out how to apply them - can you point me in the direction
of some good internet resources/examples.

thanks again
J

Dave Peterson wrote:
Tools|Options|view tab|uncheck startup task pane

Is where I'd start.

WhytheQ wrote:

Dave,
That worked fine.
Also with 2003 I get an annoying little window opening up on start-up
called "Getting Started" : couldn't see any setting in ToolsOptions
for this one -any ideas?

Thanks again
J


--

Dave Peterson


--

Dave Peterson
  #8   Report Post  
Old June 1st 06, 11:25 AM posted to microsoft.public.excel.misc
WhytheQ
 
Posts: n/a
Default Updating Links

nice one Dave
J

Dave Peterson wrote:

Debra Dalgleish has a list of books at her site:
http://www.contextures.com/xlbooks.html

You may want to look at:

Professional Excel Development
By Stephen Bullen, Rob Bovey, John Green


WhytheQ wrote:

once again I bow down to your encyclopeidic knowledge of Excel Dave!

also matey: I'm presently trying to get my head around Class Modules &
try to work out how to apply them - can you point me in the direction
of some good internet resources/examples.

thanks again
J

Dave Peterson wrote:
Tools|Options|view tab|uncheck startup task pane

Is where I'd start.

WhytheQ wrote:

Dave,
That worked fine.
Also with 2003 I get an annoying little window opening up on start-up
called "Getting Started" : couldn't see any setting in ToolsOptions
for this one -any ideas?

Thanks again
J

--

Dave Peterson


--

Dave Peterson




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
Updating Links on Excel Update Link Question Excel Discussion (Misc queries) 4 May 22nd 06 08:21 PM
Links not updating in shared workbook JP Long Excel Worksheet Functions 0 April 26th 06 09:52 PM
Updating links Brisbane Rob Excel Discussion (Misc queries) 2 April 1st 06 09:54 PM
?? Links Not Updating ?? djm023 Excel Discussion (Misc queries) 3 September 7th 05 02:10 PM
Links updating? Kimmerz321 Excel Discussion (Misc queries) 3 September 1st 05 01:31 PM


All times are GMT +1. The time now is 05:08 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017