Updating formula/links

  • Thread starter Thread starter Juha
  • Start date Start date
J

Juha

Hi,

A problem with formula:

I have a sheet that gathers information from a number of xls files.
Now when the year has changed some of those files are not necessary and
I want to get rid of them. If I just delete them, at the time of
updating links, the gathering sheet complains because it can't find
those files. I sure wouldn't like to do it cell by cell because there
are million cells to update... So is there a way to tell to the sheet
that those files are gone for good and to make it stop looking for
them???

Thanks in advance!!!
 
In xl2002, you can Edit|Links|Break links (to convert the formula to values).

In previous versions, if you've already gotten the Ref errors back, then you
could use Bill Manville's findlink.zip from:
http://www.bmsltd.ie/MVP/Default.htm

Maybe you could search for #ref's and have them deleted.

Run it against a backup copy--just in case you don't like the results.
 
Back
Top