I get an "Too many different cell formats." error message when trying to change certian cells and when updating certian pivot tables. Closing the workbook and re-starting fixes the problem some of the time.