Permanently Disable a Link

[Ken Wright]

If you know which cell the link is in, then in any version of Excel you can select the cell, then
do F2 then F9 and hit enter

If you don't know where it is, then in Excel 2002 you can use Edit / Links / Break Link

In any previous version, If you don't know where it is then download Bill Manville's free addin
from:-

http://www.bmsltd.co.uk/MVP/Default.htm

 

[Ken Wright]

My pleasure

 

[Alan Secker]

Is there a way to permanently disable a link to a 2nd
spreadsheet?

TIA

Alan Secker

 

[Biff]

Congrats Ken, in CDO you answered the question about 8 hrs
before it was asked! Gotta be a record!

Biff

-----Original Message-----
My pleasure

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

---------------------------------------------------------- ------------------
Attitude - A little thing that makes a BIG difference
---------------------------------------------------------- ------------------

version of Excel you can select the cell,

then

is then download Bill Manville's free

 

[Alan Secker]

Thanks Ken

Alan

If you know which cell the link is in, then in any version of Excel you can select the cell, then
do F2 then F9 and hit enter

If you don't know where it is, then in Excel 2002 you can use Edit / Links / Break Link

In any previous version, If you don't know where it is then download Bill Manville's free addin
from:-

http://www.bmsltd.co.uk/MVP/Default.htm

 

[Ken Wright]

Just trying to think ahead. <vbg>