Re: Workbook format lost after saving.

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

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: 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)
  • Re: CVS to XLS in Ruby
    ... ps- this is going to require windows and excel.. ... it out as an XLS file. ... formatting has held. ... some way in CVS format. ...
    (comp.lang.ruby)
  • Re: Workbook format lost after saving.
    ... Thank you so much for your prompt response. ... "macropod" wrote: ... Users are working in compatibility mode and the file extenstions are .xls. ... all formatting is ...
    (microsoft.public.excel.misc)
  • Re: CVS to XLS in Ruby
    ... i think that excel is crap so who cares.. ... it out as an XLS file. ... formatting has held. ... some way in CVS format. ...
    (comp.lang.ruby)