Permanently Disable a Link

  • Thread starter Thread starter Ken Wright
  • Start date Start date
K

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
 
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
---------------------------------------------------------- ------------------
Click to expand...
version of Excel you can select the cell,
then
Click to expand...
is then download Bill Manville's free
 
Thanks Ken

Alan

Ken said:
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
Click to expand...
 
Back
Top