A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Why does Excel spreadsheet lose format changes after saved?



 
 
Thread Tools Display Modes
  #1  
Old December 9th, 2009, 09:01 PM posted to microsoft.public.excel.setup
txlogic
external usenet poster
 
Posts: 3
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  
Old January 27th, 2010, 11:06 PM posted to microsoft.public.excel.setup
Hrafnkel
external usenet poster
 
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.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:48 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.