Jan has attended:
Project Introduction course
Excel Advanced course
Project Intermediate course
'Too many different cell formats' Error
Hello,
I'm currently getting the same error whenever I try and format a document that says 'Too many different cell formats'. I tried googling to find a fix but all the pages just seemed to want to sell me a plug in to fix it - is this something that is easily fixed at all? It's driving me bonkers.
Thanks! Jan
RE: 'Too many different cell formats' Error
Hi Jan,
Thank you for the forum question.
You get the error because the workbook contains more than 64,000 different combinations of cell formats. A combination is defined as a unique set of formatting elements that are added to a cell. A combination includes all font formatting (typeface, font size, italic, bold, and underline), borders (for example: location, weight, and colour), cell patterns, number formatting, alignment, and cell protection.
I read about a fix. If you copy the whole sheet and paste it as text in another sheet and only add needed formatting.
Another web sites suggested to open the name manager on the formulas tab and see if Excel has created references to formatted cells. There is a bug in Excel. Excel can create a lot of useless references we can find in the name manager. Specially if you have moved worksheets between workbooks.
I hope this can help you.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
