how to delete source file?

  • Thread starter Thread starter Brad Sayers
  • Start date Start date
B

Brad Sayers

An excel spreadsheet links to another excel file. However Iwant to remove
this link completely since the file does not exist anymore. How do I remove
it?

I know that by going into the spread sheet and doing a find ! I get all the
cells that call to this external file.

If I delete them all (and there are lots) will I still get the prompt when
opening the spreadsheet that it can't find this source File?

How shall I best handle this situation? Can I simply remove the source link
somehow? I don't get that option (rather, open source, change source).

TIA, Brad
 
thanks for the quick response Anne, I should have stated that this is excel
2000 and the break link option is not an option with this version....
 
Try Bill Manvilles free Findlink addin - that'll find it no matter where
it's hiding, and give you options on how to fix it :-)

http://www.oaltd.co.uk/MVP/Default.htm

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------­------------------------------­----------------
 
Back
Top