You probably have some macro running that clears the activesheet.

--
Regards,
Tom Ogilvy

"Barrie" wrote in 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.