ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Help please - worksheet reverts back to grid (https://www.excelbanter.com/excel-programming/310724-help-please-worksheet-reverts-back-grid.html)

Kevin

Help please - worksheet reverts back to grid
 
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.
.



All times are GMT +1. The time now is 10:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com