Cant Edit, Break or Find the external Link which is asking me to Update.

[ananthram]

Good Day Everyone,


i am facing a problem with a file which is prompting me to Update or Dont Update from external source and now i dont have a source file nor i cant Delete/Break the link. Please help me with fixing this problem.

 

[Hui]

Ananthram


Links to external data sources can be in a number of areas


- Data Sources (data Existing connections)

- Hyper Links

- Cell References

- Charts

- Named Formula

- Hyperlinks in Objects


You will need to check all areas until you find it


There are some addin's that can do this for you and I personally use John Walkenbach's PUP addin, which has a module for listing all the links in a workbook

It is available at: http://spreadsheetpage.com/index.php/pupv7/home/

 

[ananthram]

but i couldn't find the source any where sir... but in Alt + E + K i have 1 link which cannot be breaked.