When I can't find links, I'll use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm
Andibevan wrote:
Hi All,
I have created a complex spreadsheet that has a "Link" I can't find - i.e.
it asks me if I want to update links when I open the spreadsheet - and my
sheet cannot have this.
The link is as a result of a personalised excel add-on that contains some of
the formulas my sheet uses. - The sheet itself does not link to anything
external and I am certain of this as under EditLinks it states the path of
an excel add-on.
What do I need to do in order to stop the sheet updating each time - I have
tried putting a reference to the xla but this doesn't solve things.
Any ideas of either how to stop it happening, or how to locate the link
would be helpful.
--
Dave Peterson