Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 9th 09, 09:01 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2009
Posts: 2
Default 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   Report Post  
Old January 27th 10, 11:06 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2010
Posts: 1
Default 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.

  #3   Report Post  
Old October 18th 10, 07:18 PM
Junior Member
 
First recorded activity by ExcelBanter: Oct 2010
Posts: 1
Default

I'm having the same issue! Very frustrating.
  #4   Report Post  
Old November 19th 10, 04:40 PM
Junior Member
 
First recorded activity by ExcelBanter: Nov 2010
Posts: 1
Default

Quote:
Originally Posted by kersplash View Post
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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 spreadsheet saved as DBF4 Mary Charts and Charting in Excel 1 November 22nd 09 02:58 PM
Excel spreadsheet embedded in Word, then saved to PDF SnowFire Excel Worksheet Functions 0 April 6th 09 05:40 PM
If I restall Microsoft Offive 2003 will I lose saved files? Excell novice Excel Discussion (Misc queries) 0 September 3rd 06 11:06 PM
Can an excel spreadsheet that was saved over be restored? Chris Excel Discussion (Misc queries) 2 March 2nd 06 01:16 AM
Why does macros assigned to a toolbar lose its link when saved as Elsa Excel Discussion (Misc queries) 3 October 18th 05 09:48 PM


All times are GMT +1. The time now is 02:41 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017