ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Why does Excel spreadsheet lose format changes after saved? (https://www.excelbanter.com/setting-up-configuration-excel/250580-why-does-excel-spreadsheet-lose-format-changes-after-saved.html)

txlogic December 9th 09 09:01 PM

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.

Hrafnkel January 27th 10 11:06 PM

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.


kersplash October 18th 10 07:18 PM

I'm having the same issue! Very frustrating.

sssrrr November 19th 10 04:40 PM

Quote:

Originally Posted by kersplash (Post 959933)
I'm having the same issue! Very frustrating.

I am having the same issue, as well. For me, it started happening when I converted to Office/Excel 2010. Any number formats that were "General"
get automatically converted to another format when saved (so far I've seen all changed to either "Accounting" or "Date". This happens to the ENTIRE workbook (all tabs). Very frustrating -- it has happened now in two entirely different spreadsheets.


All times are GMT +1. The time now is 01:29 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
ExcelBanter.com