Excel 2007 : Receiving error message "Too many different cell formats” when copying tabs

I'm working in a 1,553 KB workbook that contains multiple tabs of data, tables, and charts. Several people have edited this document. Now when I try to copy a tab from another workbook into this one (using "Move or Copy"), I receive an error message saying "Too many different cell formats.” Any suggestions?

-------

I'm changing this thread to "Solved" because I just found another thread that addresses this: http://www.excelforum.com/excel-gene...l-formats.html

Welcome to the forum.

See http://support.microsoft.com/default...b;en-us;213904

Hi,

Check out the following.

http://support.microsoft.com/kb/213904

Also see if the last cell on various worksheets is sensible. Sometimes if a lot of editing has been going on the last cell may, incorrectly, be on the last row or column - or both. If the intervening cells also have a variety of formats you will no doubt have breached the approx 4000 limit on formats. If you have, delete the unused rows/columns and then Save your workbook to reset the last cells.

HTH