Cannot save formatting

  • Thread starter Thread starter nb
  • Start date Start date
N

nb

Hi, I am using Excel 2007 and saving the workbook in Excel 2003 format. I've
been working on this workbook for a few months now and it has about 15
worksheets.

All the cells were formatted, basically using about 6 styles in total.

Recently two things have happened:
1. Those six styles suddenly became a few hundred for no apparent reason
2. More seriously today the workbook does not retain any formatting when I
format it, save it and close it down. Then reopening all the formatting has
disappeared!!

These are not small workbooks so reformatting takes a long time!!

There is no conditional formatting and to my knowledge I have not tripped an
option that saves no formatting - any ideas?

Thanks
 
Check to make sure you're saving it as an excel file and not a text document
or comma delimited document.
 
It's most peculiar - until today for months the files were being saved as
Excel 2003 and all formatting was being maintained fine. Then suddenly for no
apparent reason, saving as normal (Ctrl-S) and the formatting has
disappeared. Tried reformatting and the formatting will not stay, the files
will not maintain any type of formats .....
 
Sounds to me like your file is too big. Try splitting it into two roughly
equally sized files and I bet your problem disappears.
 
Back
Top