One of two possible things come to mind. The first is file
corruption. This sounds mighty strange and could be due to
some bizzare file corruption. The second thing is macros
mis-behaving. Do you have macros that do automatic
formatting? If so, your problem may be there. If this is
what the problem is you will have to debug the macros. If
it is a corrupted file, I am not sure how to address this.
In MS Word you can copy everything except the last
paragraph marker or export to a plain text file, then
reformat. In Excel I am not sure what the solution is,
especially if you have built in equations, formatting,
forms, code, etc.

Without more information it is hard to help. Good luck!

Kevin
-----Original Message-----
Have got workbook with 30 worksheets in it. I can enter
data on certain
sheets but then the next sheet I go on all formatting
will disapear and
revert back to a blank grid- its not consistant, it can
happen anywhere in
the book. Can any one tell me why this is happening
please.
.