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.

"2-Tents" wrote:

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?

Hi Iona,

Make sure Office 2007 SP1 is installed.

--
Cheers
macropod
[MVP - Microsoft Word]


"Iona" wrote in message ...
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.

"2-Tents" wrote:

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?

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

"macropod" wrote:

Hi Iona,

Make sure Office 2007 SP1 is installed.

--
Cheers
macropod
[MVP - Microsoft Word]


"Iona" wrote in message ...
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.

"2-Tents" wrote:

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?

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

On Jan 14, 12:11*am, Iona wrote:
Thank you so much for your prompt response. However, the users have up to SP3
installed. Should we still be encountering issues?



"macropod" wrote:
Hi Iona,

Make sure Office 2007 SP1 is installed.

--
Cheers
macropod
[MVP - Microsoft Word]