THINK about how you reference a sheet that doesn't exist. Suggest you clear
the cells, especially if you intend to use Monday again next week to supply
the data for your destination sheet. Failing that approach, change your
formulas to values before deleting the source worksheet.


--
Don Guillett
SalesAid Software

"O'C" wrote in message
...
Does any one know of a way to stop excel from changing the sheet name used
in
a formula once the sheet name has been changed or deleted?

I have a weekly schedule where the days get forced in from another
application as daily sheets. Monday, tuesday, wednesday, and so on. This
causes excel to rename the duplicates monday1...etc... Or if i delete the
old days once I'm finished it will give me the #REF! error because i just
deleted the sheet name awaiting import of the new data. I don't want to
have
to go in and change all my formulas using find and replace to fix these.
I
just want it to work automatically. I want to be able to delete the
sheets
once i'm done but leave my working sheet alone and intact as is.

If you need more info, just let me know.

Thanks,
O'C