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