Workbook format lost after saving.
 

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!

Workbook format lost after saving.
 

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?

Workbook format lost after saving.
 

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?

Workbook format lost after saving.
 

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?

Workbook format lost after saving.
 

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?

Workbook format lost after saving.
 

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]

Workbook format lost after saving.
 

Hi, I am also getting the same problem and I have SP1 installed on Office
2007. Can I try anything else?


"Pete_UK" wrote:

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]

Workbook format lost after saving.
 

Same problem here. I have opened a case with Microsoft.

The problem obviously is not widespread, but Im 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?

Im 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
on hold.


"Roo" wrote:

Hi, I am also getting the same problem and I have SP1 installed on Office
2007. Can I try anything else?


"Pete_UK" wrote:

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]

Workbook format lost after saving.
 

I can also confirm the same problem.

Can't wait for a solution now!



"rootman" wrote:

Same problem here. I have opened a case with Microsoft.

The problem obviously is not widespread, but Im 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?

Im 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
on hold.


"Roo" wrote:

Hi, I am also getting the same problem and I have SP1 installed on Office
2007. Can I try anything else?


"Pete_UK" wrote:

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]

Workbook format lost after saving.
 

I have the same problem...

No answer in sight...



Frank

"Shan" wrote:

I can also confirm the same problem.

Can't wait for a solution now!



"rootman" wrote:

Same problem here. I have opened a case with Microsoft.

The problem obviously is not widespread, but Im 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?

Im 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
on hold.


"Roo" wrote:

Hi, I am also getting the same problem and I have SP1 installed on Office
2007. Can I try anything else?


"Pete_UK" wrote:

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]

Workbook format lost after saving.
 

I have exactly the same problem in my company. Office SP1 installed and it's
still not working. I'd kill for a solution ;)

"Frank the Tank" wrote:

I have the same problem...

No answer in sight...



Frank

"Shan" wrote:

I can also confirm the same problem.

Can't wait for a solution now!



"rootman" wrote:

Same problem here. I have opened a case with Microsoft.

The problem obviously is not widespread, but Im 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?

Im 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
on hold.


"Roo" wrote:

Hi, I am also getting the same problem and I have SP1 installed on Office
2007. Can I try anything else?


"Pete_UK" wrote:

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]

Workbook format lost after saving.
 

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?


"rootman" wrote:

Same problem here. I have opened a case with Microsoft.

The problem obviously is not widespread, but Im 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?

Im 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
on hold.


"Roo" wrote:

Hi, I am also getting the same problem and I have SP1 installed on Office
2007. Can I try anything else?


"Pete_UK" wrote:

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]