Workbook format lost after saving.

  • Thread starter Thread starter YY san.
  • Start date Start date
Y

YY san.

Hi, I am using Excel 2007. The file I am working on is fine until few hours
ago, I re-open the file, all the file format is gone! It looks like the
format is reset. All the number are now in 5 dec places. I manually re-format
the entire workbook, saved and re-opened it, the format is not there.
I tried to save into another file name, but still the same problem. When I
work with other files, there is no such problem.
Appreciate your help on this.
Thanks a million!
 
I am having exactly the same problem. After setting up my spreadsheet the
way I want it, I save and exit. When I re-open the file, all formatting is
gone! Nothing is centered, fonts are reset, nothing in bold, significant
digits are reset, underlining is in an odd state, etc, etc.

The only way around it for me was to save in 2007 format (.xlsx). With that
file format, my spreadsheet formatting remains intact, but nobody I work with
can open it. When I save as .xls so that they can open my files, the
formatting is screwed up.

Needless to say, my boss is not very happy because he has OfficeXP. Anyone
know of a fix for this?
 
Hello,

Has anyone received a response on this one? This has happened to a few of my
..xls worksheets now and I am getting frusterated. A handful of Users are
working with Excel 2007 and the rest are working in Excel 2003. The 2007
Users are working in compatibility mode and the file extenstions are .xls.
But the formats are getting lost and when we reformat and/or rename the
workbook it remains, almost like corrupted if you will. So thus having to
create a new spreadsheet. We are talking massive amounts of data. Is there an
issue with a worksheet being updated and saved between users. Please remember
we have our compatibility checker on.

Desperately need resolution.
 
Thank you so much for your prompt response. However, the users have up to SP3
installed. Should we still be encountering issues?

macropod said:
Hi Iona,

Make sure Office 2007 SP1 is installed.

--
Cheers
macropod
[MVP - Microsoft Word]


Iona said:
Hello,

Has anyone received a response on this one? This has happened to a few of my
.xls worksheets now and I am getting frusterated. A handful of Users are
working with Excel 2007 and the rest are working in Excel 2003. The 2007
Users are working in compatibility mode and the file extenstions are .xls.
But the formats are getting lost and when we reformat and/or rename the
workbook it remains, almost like corrupted if you will. So thus having to
create a new spreadsheet. We are talking massive amounts of data. Is there an
issue with a worksheet being updated and saved between users. Please remember
we have our compatibility checker on.

Desperately need resolution.
Click to expand...
Click to expand...
 
There are different service packs for different versions. SP3 relates
to XL 2003, but so far there has been only one SP for XL 2007 - have
you got this for your machines which run XL 2007?

Pete

Thank you so much for your prompt response. However, the users have up toSP3
installed. Should we still be encountering issues?



macropod said:
Hi Iona,
Click to expand...
Make sure Office 2007 SP1 is installed.
Click to expand...
Click to expand...
 
Hi, I am also getting the same problem and I have SP1 installed on Office
2007. Can I try anything else?


Pete_UK said:
There are different service packs for different versions. SP3 relates
to XL 2003, but so far there has been only one SP for XL 2007 - have
you got this for your machines which run XL 2007?

Pete
Click to expand...
 
Same problem here. I have opened a case with Microsoft.

The problem obviously is not widespread, but I’m seeing an increasing number
of posts regarding this issue. I'm convinced it is related to compatibility
handling of Excel 2003 workbooks in the Office 2007 environment. Oddly, it
seems limited to only some 2003 workbooks. Is there some feature or
corruption that is tolerated by Office 2003, but not by Office 2007?

I’m considering bulk conversion of 2003 workbooks to 2007 workbooks on a
hunch the problem will be masked or removed.

Hoping Microsoft will find the cause, but our desktop update project is now
 
I have exactly the same problem in my company. Office SP1 installed and it's
still not working. I'd kill for a solution ;)
 
Hi rootman. Did you ever get an answer from MS on this?
Are there no MS staff or MVPS on here who can clear this up?
 
Back
Top