I am wondering whether this is some clash between excel and windows 2000 -
Odd excel version will be 85 97 or 2000 on wY2K doubt XP)2002) erm.. i do not know why this could be of agro, have yopu upgraded excel or windows.
Though if you have change w95 with e97 to wY2K with E97 that will knacker iot as they never were built to run together tahs backwards if you get me,. but other that that should run ok...
OK try resave as new XYZ and also export sheet by sheet into new book to break the cycle.
to be fair withoutthe wkBk in lost.. need to see really, i would rip it apart and re save as .
To rip abart o would copy only the data from each sheet and paste over and name everything as original save everyu two seconds incase crashes...
and rebuild teh wkbk this way. yhis means only data is transfered over, not rubbish, and also as i say never copy macros export them when written and import the bas file into this new book keeps things cleam,
Its a rebuild job and will hopfully trigger the sheet to be friendly.
Soounds like loads of work but might jut do the job...