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

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

Updating Links
 

cheers Dave.

Jason

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

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

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

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

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