Removing all links from an excel workbook

[Guest]

Is there a global way to remove all links at one time in a workbook or do I have to manually select each linked cell and remove the link individually? Any shortcut toward the removal of links would be very helpful. Thank you.

 

[JMay]

Go to Google; Someone offers code to do this (I can't remember who,
where,,,)

Is there a global way to remove all links at one time in a workbook or do

I have to manually select each linked cell and remove the link individually?
Any shortcut toward the removal of links would be very helpful. Thank you.

 

[Ken Wright]

In Excel 2002 / 3, do Edit / Links / Break Links

In previous versions, go get a copy of Bill Manville's free FINDLINK.xla which
will find and deal with links for you:-

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

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

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

Is there a global way to remove all links at one time in a workbook or do I

have to manually select each linked cell and remove the link individually? Any
shortcut toward the removal of links would be very helpful. Thank you.