Cannot insert sheets

[sburkhar]

What can I do about the error below? The excel sheet is clearly large enough to handle it. I'm using the "move or copy" function.

"Excel cannot insert the sheets into the destination workbook, because it contains fewer rows and columns than the source work book."

Is there away around this problem?
excel 2010

 

[Trevor G]

You have 2 choices: Resave the workbook to 97-2003 as this has 65536 rows. Or resave the workbook you are copying it from to a 2010 version before you try and copy it. This is due to compatibility.

 

[sburkhar]

thank you. I was able to move it to a NEW workbook and then move my other documents over. Kind of backwards but at least it's getting done. Thanks again