Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linked sheets problem!!
try going to EDIT/ LINKS in the task list and break the connections
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linked sheets problem!!
try going to EDIT/ LINKS in the task list and break the connections
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding row in two sheets which are linked | Excel Discussion (Misc queries) | |||
Linked sheets | Excel Discussion (Misc queries) | |||
Problem with linked sheets | Excel Discussion (Misc queries) | |||
Linked Workbooks/Sheets | Excel Discussion (Misc queries) | |||
linked sheets | Excel Discussion (Misc queries) |