Excel cant SAVE added data?

[Ken]

This is a copy/paste with minor edits from post submitted
yesterday ...

Excel 2000 ... I have a single page spread sheet (my
own) ... built in Excel 2000 (still Excel 2000) that was
working fine.

After expanding the spread sheet to handle more
equipment I received error message stating:

Excel can not SAVE all of the added data & formatting ...

Here I had the option to select OK without fixing ...
CANCEL ... or ... HELP. I selected HELP & ended up on a
blank HELP Page ... So now I am turning to this board.

Anybody know what gives? Could I be running into a
formatting limit issue? Sheet less than 1000 rows, but
many formulas & formats (including Conditional Formats)

Thanks ... Kha

 

[Dave Peterson]

Excel has a limit of 4000 different formats in a workbook.

XL: Error Message: Too Many Different Cell Formats
http://support.microsoft.com/?scid=213904

Sometimes this pops up when you're opening a workbook. I've seen posts that say
some people have used OpenOffice to open, reformat, save and not lose their
data.

(http://www.openoffice.org, a 60-65 meg download or a CD)

 

[Todd]

Get http://on-disk.com/product_info.php?products_id=29 which contains
the OpenOffice.org 1.1 install for Microsoft Windows XP, 2000, ME,
98,95, Mac osX, Linux Intel, Linux PPC, Solaris Intel, Solaris Sparc,
FreeBSD

It should be able to fix it for you.