Excel 2007 & Custom Number Format Limitations?

T

TC

I'm used to getting those error messages in Excel about too many custom
number formats and I was wondering if this is still the case with Excel 2007
as I'm planning to migrate soon.

Thanks.
 
J

Jim Rech

Funny you should ask that as I just read the message from Venkat timestamped
2 hours later than yours. The limit to unique cell formats was increased a
lot in Excel 2007 and, absent his message, I'd have said case closed. But
VerKat said he had a workbook with that problem in Excel 2003 that when
opened in Excel 2007 lost all its cell formats. Go figure. I have both
versions and I'd be happy to try your file in 2007. You can clear the
sheets of any private data/formulas just so the formats are there.
 

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

Similar Threads

Conditional custom number format? 5
Maxima for custom lists for Excel < 2007 2
Data exported to excel 2007 changes cell number format to 'general' ? 1
Excel 2007 Custom Formatting using [ColorXX] 4
Excel 2007 Ribbon - Remove unwanted custom toolbars 2
Excel 2007: How to change fill color in Theme Colors 2
lost in 2007 6
Assign custom number format to the ribbon 0

Top