problem while saving the file as .xslm format in excel 2007

[soham shah]

I have created a file in office 2003. I have kept certain colums as
'Date', certain as 'Number' etc. In short, cell formatting has been
applied in the file.

Now I am opening this file in a PC which has office 2007. I can see all
the cell formatting in this file even in excel 2007.

Now I am saving this file as .xslm format on that PC.

Now when I am opening this file, 90% of the cell formats have been
vanished while 10% are still there . I dont know why I m losing out
certain formats in tehre ..

 

[Barb Reinhardt]

How are you saving it as an XLSM? Manually or with code? I ask because I
had strange things happen when I saved programmatically using the wrong
syntax.

Barb Reinhardt