Links

Siri · Nov 18, 2003

Every time I open a spesific workbook, I get the question if I want t
use the old or the new data. This is very irritating! How do I disabl
the link that is the reason for this message??? Please help me befor
this drives me CRAZY!!

Nick Hodge · Nov 18, 2003

Siri

You will have a formula somewhere within the wordbook that is linked to
another workbook. You can look for them manually and the copy>paste
special>values... to kill it. or you could download Bill Manville's
findlink.xla utility.

this can be found at

http://www.bmsltd.co.uk/DLCount/DLCount.asp?file=FindLink.zip

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]