Name Define formula problem

Hello,

I have a formula in the Name Define part of excel in workbook that refers to another workbook.

=IF(COUNTIF([DaysWorking.xls]Sunday!$A:$A,'2009'!I1)>0,1,"")

The DaysWorking.xls workbook is a data workbook, users may change the data and after they are done, they may exit the program but not save it. The DaysWorking.xls workbook should always revert back to the original form. I've put a read only property on it, but the problem lies when the user saves the file under Save/As function. Excel then updates the link to whatever the user saves the file as. Is there a way to make sure that the formula never get's changed?

Thanks for any, and all help,
tja.

I am presuming that given you're using COUNTIF the target file is always open when the file containing the name is in use ? In which case you could potentially use INDIRECT to construct the reference ?

=IF(COUNTIF(INDIRECT("[DaysWorking.xls]Sunday!$A:$A"),'2009'!I1)>0,1,"")