Breaking links leaving invalid reference #REF! in cell

[Kenny Boy]

Help Please,

I currently extract data from an automated system that generates a daily
spreadsheet. If the file does not exist it gives me an invalid reference
which is fine since I know it does not exist yet. When the daily sheet is
created I can then extract the data I need.

The problem is that the cells for future dates show the #REF! in the cell
even after I break the links causing the autosum for my totals to be false.
This creates more work deleting than just dragging, dropping then using edit
find/replace for the new dated spreadsheet daily.

I would like to leave the invalid reference shown as zero or just a blank
cell if the reference is invalid.

Any suggestions or do I need to create a macro. If so how would I go about
this?

 

[Kenny Boy]

I figured it out, I was unaware of the ISERROR function. I put that infront
of my linked data/formulas and it works beautifully. Now when I break the
links and save as a different file, the formulas don't even show up. This is
exactly what I wanted. Who needs to know that the computer does the work for
you and no human error involved!!!! HE HE HE!!!!

Did I say I love excel!!! OK I LOVE EXCEL!!!!!