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?