ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Links and Linking in Excel (https://www.excelbanter.com/links-linking-excel/)
-   -   Break Links in Excel 97 (https://www.excelbanter.com/links-linking-excel/130048-break-links-excel-97-a.html)

CraigH

Break Links in Excel 97
 
Since Excel 97 doesn't offer a "Break Link" option, how can I break a link
between two workbooks?

Thanks,
Craig.


Dave Peterson

Break Links in Excel 97
 
If those links are in worksheet formulas, you can convert those formulas to
values (edit|copy, edit|Paste special|values).

Try Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

It'll make them easier to find.

CraigH wrote:

Since Excel 97 doesn't offer a "Break Link" option, how can I break a link
between two workbooks?

Thanks,
Craig.


--

Dave Peterson


All times are GMT +1. The time now is 11:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com