Software

Ask something
Discussion Locked

Linking Workbooks in Excel

0 helpful
5 replies

by nk

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How do you unlink workbooks? I know that there is a links option in the Edit menu but that only allows you to update the link. It does not allow you to remove the link.

5 replies

by dklippert

You'll have to locate the formulas that are referencing the other spreadsheet and remove the reference. The workbook will then stop asking for update information.

by nk

How do you located the formulas referencing the other spreadsheet?

by dklippert

There are a couple of ways, depending on the size of your spreadsheet.
1) touch F5 (GoTo). Choose Special and Formulas. All of the formulas on that sheet will be highlighted and you can Tab through them to locate the relevant entries.
2)Ctrl+~ (Control+ tilde) will toggle all formulas to be displayed.
3) Use Edit>Find to locate something like: !, .xls, [ or other components of a formula that indicate links.

This discussion is closed to new replies.