Formatting lost when saving in Excel 97-2003

[KManoj]

My office desktop has Office 2007 installed, and my home has Office 2003. To
use at both places, I save my excel files in 97-2003. In a big file, i have a
peculiar problem - the formatting is lost when I open the file. I had no
problems till now and was using it normally. When i convert it into 2007
xlsx, if i close and open the file, the formatting remains. If i save it in
2003 xls, then i lose the formatting again.

Even the dates (whether typed as 11/26/2008 or today() )show as numerical
values..

Any idea why this might happen??

 

[Shane Devenshire]

Hi,

Excel 2007 allows many types of formatting that 2003 does not, all of those
will be changed or lost.

In complex files 2007 may support more styles 4000 in 2003, 65,536 in 2007
if you exceed the 2003 limit all the others will be lost for sure, but it may
be that all formats are lost if you exceed the 4000 limit. If so this is a
bug.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

 

[cmlee2289]

Hi,

My team has the similar problem using Excel2003 where oponing the file saved
last time, all the formats lost totally left with recovered file where only
simple sum formulars and linkings amongst the sheets have changed to values.
This Excel 2003 file can be opened in Excel 2007 that only text box looks a
bit different.

We seeking your helps and thanks in advance. Warmest Regards,