RE: Workbook format lost after saving.
- From: Iona <Iona@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 9 Jan 2009 16:15:02 -0800
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?
- Follow-Ups:
- Re: Workbook format lost after saving.
- From: macropod
- Re: Workbook format lost after saving.
- Prev by Date: Re: Adding time after calculation
- Next by Date: RE: assigning id's
- Previous by thread: RE: Quarterly Statements in Pivot Tables
- Next by thread: Re: Workbook format lost after saving.
- Index(es):
Relevant Pages
|
