ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Copy/ paste Error " Too many different formats" (https://www.excelbanter.com/excel-worksheet-functions/188953-copy-paste-error-too-many-different-formats.html)

veejay

Copy/ paste Error " Too many different formats"
 
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

Copy/ paste Error " Too many different formats"
 
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...b;en-us;213904

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

Hope this helps.

Pete

On May 27, 3:17*pm, veejay wrote:
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




All times are GMT +1. The time now is 01:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com