delete links

RichN · Feb 7, 2007

Microsoft Excel 2000
someone who used my file before me linked the file to several other files.
the links are no longer needed. how do i delete them?

Simon Murphy · Feb 8, 2007

Edit>>Links>>break link

or try FindLink from here(free)
http://www.oaltd.co.uk/MVP/Default.htm

In either case its sets the linked formula to its last value.

cheers
Simon
Blog: www.smurfonspreadsheets.net
Website: www.codematic.net Excel development, support and training

RichN · Feb 9, 2007

No such command "Edit>>Links>>break link" in Excel 2000.

and the FindLink file won't work - does it need some sort of .DLL file?