Ignore file links that do not exist.

[Guest]

Hi everyone

I have a standard file structure containing reports (MS Excel format) for
each day of the year.

I have anothe spreadsheet which links to these reports with no problem.
However I have to generate new links for each report as it is received. For
example at the end of February I will check all the reports have been filed
and then using a simple Copy/Paste and then Find/Replace will generate the
links for February based on the formulae for January.

What I would like to do is generate the whole year's links in one go without
MS Excel constantly trying to update values for files that do not exist yet.
I have tried the ISERR() function to see if MS Excel would ignore those files
that do not exist but this did not work. I have also played with the
HYPERLINK() function but could not get this to do anything desirable.

I also tried the Update Links drop down option but the Manual Update radio
button is greyed out.

Any help much appreciated
Dave

 

[Guest]

Maybe I am being a bit waffly in my explanation!

I have a set of formulae of the type below:

=SUM('V:\DailyReports\Brasil\2006\[BRA-2006-01-31.xls]EquipDataCollation'!$D$5:$F$5)

I am transferring the generation of quarterly reports to others and wish to
make it as easy as possible for them to update data. Therefore I would like
to generate formulae of the form above relating to files that do not yet
exist.

What I can't seem to get Excel to do is ignore formulae where the file it
refers to does not exist yet.

I hope this helps explain the problem.
Dave