Linked sheets problem!!
 

Morning,

I am having a big problem with links. My spreadsheet used to be linke
to one called CurrentStock.xls and it still thinks it is even thoug
there are no formulas which relate to this sheet and no Names mentio
this sheet. Is there any way to sort this out please?

Thanks in advance

John

p.s. im using xl200

--
johncassel
-----------------------------------------------------------------------
johncassell's Profile: http://www.excelforum.com/member.php...fo&userid=2501
View this thread: http://www.excelforum.com/showthread.php?threadid=39939

Linked sheets problem!!
 

there are no formulas which relate to this sheet and no Names mention
this sheet. Is there any way to sort this out please?


Microsoft make available a DelLinks utility to clean up bad links at
http://support.microsoft.com/kb/q188449/
XL: Delete Links Wizard Dellinks.exe

Also see http://visualbasicforum.com/showthread.php?t=153705
Bill Manville tools Findlinks (available at Stephen Bullens site
http://www.bmsltd.ie/) also include some documentation about it as well.
Jan Karl Pieterse Namemanager (available at Stephen Bullens site as well).

For more info, see http://www.sysmod.com/spreads.htm

Patrick

Linked sheets problem!!
 

Thanks for the reply. That didn't actually find anything for me, bu
eventually I worked out where they all were.

Thanks again

Joh

--
johncassel
-----------------------------------------------------------------------
johncassell's Profile: http://www.excelforum.com/member.php...fo&userid=2501
View this thread: http://www.excelforum.com/showthread.php?threadid=39939

Linked sheets problem!!
 

try going to EDIT/ LINKS in the task list and break the connections

Linked sheets problem!!
 

try going to EDIT/ LINKS in the task list and break the connections