If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Why does Excel spreadsheet lose format changes after saved?
I have Excel 2007 but have to save files in 97 Format (.xls). I have a
spread sheet that I have formatted the cells for accounting, number and percentages formats. Everything looks great until I save the file, than when I re-open it all the formatting changes I made are gone, but if I save the file in .xlsx format everything works fine. Unfortunately, several of the users who need access to my file are still using 97 Excel; so, I have to find a way to save this file with the proper format. |
#2
|
|||
|
|||
Why does Excel spreadsheet lose format changes after saved?
I have been having the exact same issue over the last six months or so. The
problem only seems to be getting worse. I have scoured the internet looking for solutions, but I'm unable to find any concrete reasons as to why this is happening. It would be awesome to find a resolution to this. "txlogic" wrote: I have Excel 2007 but have to save files in 97 Format (.xls). I have a spread sheet that I have formatted the cells for accounting, number and percentages formats. Everything looks great until I save the file, than when I re-open it all the formatting changes I made are gone, but if I save the file in .xlsx format everything works fine. Unfortunately, several of the users who need access to my file are still using 97 Excel; so, I have to find a way to save this file with the proper format. |
Thread Tools | |
Display Modes | |
|
|