Re: Workbook format lost after saving.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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" <Iona@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:287A569E-505A-457E-BBE0-2E85EB585AC8@xxxxxxxxxxxxxxxx
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?


.

Relevant Pages

  • Re: Excel File corrupted by word file
    ... You can paste Word stuff into Excel. ... Conditional formatting - gone. ... The most likely thing is that someone opened the xls file in Word, ... Spreadsheet functionality ...
    (microsoft.public.excel)
  • Re: Mail Merge and Incorrect Formatting
    ... "macropod" wrote: ... To control percentage formatting in Word, add a formula and numeric picture switch to the mergefield. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: How to preserve format on cross-references when update
    ... Ah, but what if the user wants something different to emphasise the link (eg a character style, or hard formatting)? ... Graham Mayor - Word MVP ... macropod wrote: ... the 'preserve formatting' option is only displayed via the ...
    (microsoft.public.word.docmanagement)
  • Re: Excel Line Feed Character - How to delete the CHR(10) and keep the formatting without going
    ... I Could record a macro but the text is different depending on the contact.. ... "macropod" wrote in message ... The Chrforces a line-break at a specified point and you can't exactly reproduce that in with text wrapping alone. ... I need to be able to delete the Chrand keep the formatting by a macro if possible. ...
    (microsoft.public.excel)
  • RE: Workbook format lost after saving.
    ... ..xls worksheets now and I am getting frusterated. ... Users are working in compatibility mode and the file extenstions are .xls. ... all formatting is ... Nothing is centered, fonts are reset, nothing in bold, significant ...
    (microsoft.public.excel.misc)