2007 to 2003 formatting troubleshooting

D

Dave H

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

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top