update links not being removed in when open in excel 2000
 

We have a load of workbooks and have run some code to remove all links.
This works fine when it is opened in 2003 (the version they were created
on), however when open in excel 2000 the prompt comes to update the links.
Does anyone know what changes have been made in 2003 so that this occurs,
and also is there some code I can run on 2003 which will make it so that if
they are opened in 2000 this will not happen. hope this makes sense.
thanks

update links not being removed in when open in excel 2000
 

In xl2002 they added an option under the links menu to suppress the prompt to
update links (without doing the update silently). In xl2000 there is no such
option. The choices are to update links without prompt. have the prompt.
Open the workbook with code where you have the ability to make the choice.

--
Regards,
Tom Ogilvy


"Graham Whitehead" wrote:

We have a load of workbooks and have run some code to remove all links.
This works fine when it is opened in 2003 (the version they were created
on), however when open in excel 2000 the prompt comes to update the links.
Does anyone know what changes have been made in 2003 so that this occurs,
and also is there some code I can run on 2003 which will make it so that if
they are opened in 2000 this will not happen. hope this makes sense.
thanks

update links not being removed in when open in excel 2000
 

I don't use multiple versions of excel.

But is there a chance you missed one of the links?

When I can't find links, I'll use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

Graham Whitehead wrote:

We have a load of workbooks and have run some code to remove all links.
This works fine when it is opened in 2003 (the version they were created
on), however when open in excel 2000 the prompt comes to update the links.
Does anyone know what changes have been made in 2003 so that this occurs,
and also is there some code I can run on 2003 which will make it so that if
they are opened in 2000 this will not happen. hope this makes sense.
thanks

--

Dave Peterson