Excel - losing formatting

[davecalv]

I have a large c20mb spreadsheet.
I save a copy each week so that I can refer back in the future.

As soon as I use the "SAVE AS" facilty, or change the filename in Explorer I lose:

All freeze panes change position
Collapsed rows and columns uncollapse
Column widths change (narrow).

Result is I spend a whole bunch of time putting it all back to how I had it before I saved it.

It's driving me crazy...What am I doing wrong.?

I'm using XP Office Pro with XP Professional O/S

 

[PaulTEG]

Try copying the file from the OS, rather than saving as another file.

I have no idea why this would be happening

Paul

 

[davecalv]

Tried doing it in explorer by copying to another directory, renaming the copy and transferring back to required location.

Still loses all formatting.

 

[Zathras]

It sounds like you are opening up a .csv file then doing a lot of formatting then clicking Save As... from the menu without changing the "Save as type:" to "Microsoft Excel Workbook (*.xls)"

If you don't change the type, Excel saves it as a .csv file the way it came in, and .csv files don't have formatting and column width information in them.