How do I remove links to external excel files

[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

 

[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.

 

[Satish Pabari]

Click on EDIT select LINKS and go from there.