Forum Discussion
External Links not breaking
I have created a budget template that includes the prior years budget amount. When I copy the template tab to a new book and then break the links to the original book, all of the links are broken EXCEPT those to the budget data. The external link remains in the 'edit links' list even after clicking on 'Break Links'. The linked file and formula remains in the cells where the budget data is referenced (using a SUMIF).
As there are external links, first opening of this document the user is prompted to update the links, which I do not want to happen as clicking 'update' will cause #VALUE.
Any advice
3 Replies
- 1. Clicking Break links is never a good idea (Excel tries to replace cell references with hard-coded values in unexpected places)
2. Key is finding where the links are and deciding whether they need to be changed to e.g. point to cells in the current workbook rather than the original workbook.
That being said, best is to first check your formulas for existence of the text .xls by doing Find, in entire workbook, in formulas. But be aware links can hide in many places so better is to download FINDLINK from Bill Manville: https://manville.org.uk/software/findlink.htmJKPieterse Thanks for a response but it doesn't address my issue. I actually want hard coded numbers replacing the cell formulas, hence the wanting to break the links.
I do not need to find the links, so I do not want software to do that (its not actually that hard).Any other proper answers?
- I think my answer qualifies as proper. Given that breaking the link does not remove it, you do need the software I referred to to get rid of it.
