ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Links and Linking in Excel (https://www.excelbanter.com/links-linking-excel/)
-   -   Locating Links and Removing (https://www.excelbanter.com/links-linking-excel/142309-locating-links-removing.html)

rmcompute

Locating Links and Removing
 
Every time I load this worksheet it prompts me to update the links. The
worksheet it's looking for does not exist. How can I determine where on the
spreadsheet the logic is located which uses this link so I can remove it ?
(It is a large spreadsheet.)

Linda@LLBean

Locating Links and Removing
 
There is an excel add-in "out there" that will help you find all the excel
links w/in a document. I often have the same problem (it's really not a link
but a reference name!). Contact me off-line and I can send you the Add-In.
(I don't remember where I got it!).



"rmcompute" wrote:

Every time I load this worksheet it prompts me to update the links. The
worksheet it's looking for does not exist. How can I determine where on the
spreadsheet the logic is located which uses this link so I can remove it ?
(It is a large spreadsheet.)



All times are GMT +1. The time now is 02:25 PM.

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