Tuesday, February 04, 2014

Microsoft's Instruction What to Do When: "You receive a 'Too many different cell formats' error message in Excel"

"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”

All menu option for "Paste" or Ctrl-V keyboard shortcut are ignored and produce no results although clipboard is not empty."
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.

No comments:

Hasleo Data Recovery FreeV3.2 - Free as in Freeware - Permanently from Hasleo Software

https://www.hasleo.com/win-data-recovery/free-data-recovery.html "Hasleo Data Recovery FreeV3.2 100% Free Data Recovery Software...