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.

"nb" wrote:

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

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 .....

"scuba" wrote:

Check to make sure you're saving it as an excel file and not a text document
or comma delimited document.

"nb" wrote:

Sounds to me like your file is too big. Try splitting it into two roughly
equally sized files and I bet your problem disappears.

"nb" wrote:

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 .....

"scuba" wrote:

Check to make sure you're saving it as an excel file and not a text document
or comma delimited document.

"nb" wrote: