How do I remove links to external excel files

  • Thread starter Thread starter TinaS
  • Start date Start date
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
 
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.
 
Back
Top