Copy/ paste Error " Too many different formats"

[veejay]

Hi, I hope someone can help me with this issue
I get an error message "too many different formats" when I try to add a tab
to the existing excel working doc. Not sure if there is a limit to the number
of worksheets a doc can hold?
thanks
vj

 

[Pete_UK]

There was a limit on the number of different cell formats in Excel
2003 and earlier, as explained in this Knowledge Base article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;213904

Essentially, you should simplify your design and remove some of the
formats you are using.

Hope this helps.

Pete