• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Too many formats

G

GN0001

Member
Hello team, I am working on two Excel workbook and I am trying to copy and paste some stuff from one workbook to another workbook. It doesn't allow me and it says: too many formats. I cleared format and I cleared all, still I can't copy and paste. Even I cleared all the objects, I started a new sheet; It doesn't allow me to do so. . Any tips?

Kind Regards,
GN
 
Just do a "save as" with the original and give your "saved as" a new name, delete what you do not whant in the new workbook.
 
Use a newer version of Excel
Up to 2007 Excel had a limit of 400 cell formats
It is now limited by your available memory
 
bobhc said:
Just do a "save as" with the original and give your "saved as" a new name, delete what you do not whant in the new workbook.
Click to expand...
I will try it and get back to you if there is any further issues. Thanks for your time to reply to this request. GN0001
 
You must log in or register to reply here.
Back
Top