"In Microsoft Excel 2003, when you format a cell or a range of cells, you may receive the following error message:
Too many different cell formats.
Excel encountered an error and had to remove some formatting to avoid corrupting the workbook.
In Microsoft Excel 2013, 2010, or 2007, files may produce the following error message:
Excel found unreadable content in the file
Other scenarios that are associated with styles are:
1. When opening a file all formatting is stripped out.
2. File size grows after copying and pasting between workbooks
3. Inability to paste:
Microsoft Excel displays
“Microsoft Excel can’t paste data”This is apparently a big issue. There is link to the great freeware XLStylesTool for removing corrupt and excessive styles...Apparently there is a similar tool for Binary Excel formats (xls, xlsb) or Password Protected/Encrypted workbook files called Remove Styles.
All menu option for "Paste" or Ctrl-V keyboard shortcut are ignored and produce no results although clipboard is not empty."