Break Link in Excel 97

[M P]

I just notice that there is no Break Link feature on MS Excel Version 97. Is
there a way where I can break the link of a file? I can do that on excel xp.

Mark

 

[Stefan Hägglund [MSFT]]

Hi Mark!

There is a addin called "dellink.xla" that you can use to delete the link
(see http://support.microsoft.com/?id=188449), but if you need to keep the
results from the link, then you have to manually copy the cells, and paste
it as values, or use Excel 2002 or 2003 to remove the link.

Best regards

Stefan Hägglund
Microsoft

 

[Max]

You could also try Bill Manville's excellent "FindLink" utility

It's available at Stephen Bullen's page:
http://www.bmsltd.ie/MVP/Default.htm