PDA

View Full Version : Fix excel error "Too Many different cell formats"



naris
12-14-2010, 01:41 AM
I have a workbook have error message "too many different cell formats", anyone can help me to fix it ?...:help

Thanks
Naris

Bob Phillips
12-14-2010, 03:00 AM
See http://support.microsoft.com/kb/213904

edwards142
12-25-2016, 11:19 PM
In Microsoft Office excel, when you format a cell or range of cells, you will get the following error message:
“Too many different cell formats.”
Usually it is observed that this error occurred because of the following issues:


• If two or more cells share the same formatting, they use one formatting combination, if there are any difference in formatting between the cells, each cell uses a different combination.
• Data pasted from other sources, such as the Internet
• In Excel, style counts may increase when you copy between workbooks because custom styles are copied.

Well to know about what resolutions steps you can do to fix this error, you will surely get help from the tutorial as I too have got.


repairmsexcel.com/blog/how-to-fix-too-many-different-cell-formats-error-message-in-excel