Hi there,

I have created a workbook to record the number of cases we received for each issue we deal with to make it easier to make my departments weekly reports. I sent out reporting workbooks to my colleagues who fill them in and send them back daily, these are all referenced to and the values are automatically updated into the master sheet.

At the end of the week I thought that I should be able to delete that weeks values and just add the new weeks sheet and it would be the same.

The problem I have is that if a colleagues workbook is deleted and there is not another one there to replace it, it seems to retain the information and does not clear the value.

The formula I am using is:

=IF(ISERROR(SUM('\\dunoffice01\DATA\share\Commercial\Client Management\New Business-Business Partners\Current Clients\New Media\Kana Reports\working week\Friday\[Kana Caroleann.xls]Errors'!C2)), 0,SUM('\\dunoffice01\DATA\share\Commercial\Client Management\New Business-Business Partners\Current Clients\New Media\Kana Reports\working week\Friday\[Kana Caroleann.xls]Errors'!C2))

The purpose of this formula is to stop me getting errors when the workbook is not present and I thought to substitute a zero if the workbook was no longer present but it doesn't seem to work that way. It stopped the error I was initially getting but does not put in the zero value if the workbook was there and then was deleted.

Any ideas?