Prev: how to split a large excel file into multiple smaller exel fil
Next: Split cells across multiple columns
From: Dave H on 17 Feb 2010 11:08

I am having issues saving a 2007 spreadsheet back to 2003. It is not
possible at this time to upgrade my end users. I have tried copying a
single blank cell into a new workbook deleting any links any named
ranges nothing hidden. When I try to save the new workbook I get
warning "This workbook contains more unique cell formats than are
supported by the selected file format. Some cell formats will not be
saved." Any suggestions on how to figure this out so I can correct the
issue and save a spreadsheet back to excel 2003?




--
Dave H
From: Gord Dibben on 17 Feb 2010 15:20
You say this happens even with a new workbook in 2007?

All I can find for this message is found at

http://office.microsoft.com/en-us/excel/HA100778231033.aspx?pid=CH100648071033

This workbook contains more unique cell formats than are supported by the
selected file format. Some cell formats will not be saved. In Excel 2007,
you can use 64,000 unique cell formats, but in earlier versions of Excel,
you can only use up to 4,000 unique cell formats. Unique cell formats
include any specific combination of formatting that is applied in a
workbook.

Has your default New workbook been altered by adding a BOOK.xltx into your
XLSTART fiolder?


Gord Dibben MS Excel MVP

On Wed, 17 Feb 2010 16:08:12 +0000, Dave H <Dave.H.5c1fd62(a)excelbanter.com>
wrote:

>
>I am having issues saving a 2007 spreadsheet back to 2003. It is not
>possible at this time to upgrade my end users. I have tried copying a
>single blank cell into a new workbook deleting any links any named
>ranges nothing hidden. When I try to save the new workbook I get
>warning "This workbook contains more unique cell formats than are
>supported by the selected file format. Some cell formats will not be
>saved." Any suggestions on how to figure this out so I can correct the
>issue and save a spreadsheet back to excel 2003?

 | 
Pages: 1
Prev: how to split a large excel file into multiple smaller exel fil
Next: Split cells across multiple columns