Why does Excel spreadsheet lose format changes after saved?

T

txlogic

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.
 
H

Hrafnkel

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converted xlsx file to xls. New xls file isn't right, try to correct, fails compat checker 0
set Excel 2007 as default to save files in Excel 2003 .xls format 1
How to find each occurence of incompatibility? 1
Why is formatting lost when saving from .xlsx to .xls? 2
Excel 2007 saving in wrong format? 4
Excel 2007 Saving Cell types in XLS format 1
Lose macros before saving 4
Excel 2007 display problem with Windows 7 1

Top