Prev: text is getting cut off when printed due to row ht.
Next: excel 2007 query question
From: BruceTho on 18 Nov 2009 15:56
Krisml:
I have been fighting this same "error" for two weeks, and it is impacting a
huge Budget workbook with about 10 worksheets that are interlinked. The most
bothersome were cells that have date formates, becasue they all change to
numbers. But all of the simple formats, like numbers as currency keep
changing also, to unformatted numbers that fill the entire cell with
decimals. And the fonts keep changing also.

In desperation I went out a bought a new computer, with XP installed as the
operating system, and I installed Office 2007 (Home & Student Edition).

After 3 days, it seemed like I was still in trouble. Then I got some help,
who advised me NOT to save down to older versions. Because lots of floks in
my company do not have new Office versions, I have always saved my Excel file
with the "Save As" button, as "Excel 97-2003 Workbook" format.

I have finally verified (still tentatively) that my "Save As" procedure is
causing this format error problem.

If I do not Save As, but instead just save the file as an "Excel Wookbook"
(which is the default, without using Save As), then the formatting I set up
stays put.

So I believe I can now complete my task of building this huge budget,
without wasting hours each day revising cell formats.

Hope this helps you.
Bruce
--
BruceTho


"Krisml" wrote:

> When I am working in excel- and I try editing the format of a cell (like
> merging 2 together) I get a pop-up that tells me "Too Many Different Cell
> Formats".
>
> It doesn't give me any options of what that means- or how to fix it.
>
> Has anyone encountered this problem? I really need help.
>
> Any replies appreciated-
 | 
Pages: 1
Prev: text is getting cut off when printed due to row ht.
Next: excel 2007 query question