How do I remove links to external excel files

T

TinaS

I need to remove the links to another excel file from my
new workbook. How can I accomplish this without re-
creating the spreadsheet from scratch?

Thank you.
TinaS
 
D

Dave Peterson

Remove links means convert those formulas to values?

If you can find them, just copy|paste special|values.

But they can be difficult to find. I'd use Bill Manville's addin to help find
the pesky ones.

Findlink.zip from
http://www.BMSLtd.co.uk/mvp

(And it's easy to use.
 
Top