Too Many Different Cell Formats Error – Excel 2007/Excel 2010

This error can arise when you go to paste data at the end of a list or in a large spreadsheet where some of the following conditions apply: