Mike, thanks for the replies,
and for sharing with us the replacement steps

Got it working by replacing the sheet...
I restored my position at that time by using my last back-up (T-1 <g),

then re-doing the work pertinent to that particular sheet. Cheers.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
mikelee101 wrote:
A step I didn't do that would have come in handy was replacing references to
Monthly in charts. Forgot that one and it jacked up my charts a bit.
However, just went in and replaced #REF! with Monthly! after everything and
now it works again.

Thanks again.
--
Mike Lee
McKinney,TX USA


"mikelee101" wrote:

Greetings Max,
Got it working by replacing the sheet. Here were the steps if anyone ever
needs to repeat. The broken sheet was named Monthly.

-Inserted a new worksheet, named it Monthly2
-Selected all of Monthly and copied/pasted to Monthly2
-Tested the cells with validation on Monthly2 and they worked.
-Changed any defined names that referenced Monthly to reference Monthly2.
-Changed any fomulas that referenced Monthly to Monthly2. (did these last
two with VBA due to the large numbers, but they could easily be done manually
if it's not too many.)
-Deleted Monthly
-Renamed Monthly2 to Monthly.

Back in business.

Thanks for the input. Happy Holidays.
--
Mike Lee
McKinney,TX USA