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 EXC...
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.htm
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.htm
JKPieterse 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.