Excel Help

Question

I have a tab in an Excel workbook that I want to use the Move or copy function (by right clicking on the tab itself) to put it in another workbook, but I keep getting the following error:

"Excel cannot insert sheets into the destination workbook, because it contains fewer rows and columns than the source workbook.  To move or copy the data to the destination workbook, you can select the data, and then use the Copy and Paste commands to insert it into the sheets of another workbook."

If I follow the advice and use the copy paste commands instead it loses the filters and other formatting that I have done.  I can use the copy/move command just fine when I move it to a new workbook.  What could be causing this?  Please help.

Answer 1

Hi Jennifer,

I have a tab in an Excel workbook that I want to use the Move or copy function (by right clicking on the tab itself) to put it in another workbook, but I keep getting the following error:

"Excel cannot insert sheets into the destination workbook, because it contains fewer rows and columns than the source workbook.  To move or copy the data to the destination workbook, you can select the data, and then use the Copy and Paste commands to insert it into the sheets of another workbook."

If I follow the advice and use the copy paste commands instead it loses the filters and other formatting that I have done.  I can use the copy/move command just fine when I move it to a new workbook.  What could be causing this?  Please help.

 I suspect that the destination workbook is in the pre-Excel 2007 xls  format  while the source workbook is in xlsx or xlsm format. 

If this were the case, the sheets of the destination workbook would be limited to 65536 rows, whereas the sheets of the source workbook would have 1048576 rows.

Try, therefore, saving the destination workbook in xlsx format and then copy/move the required sheet. If necessary, after copying the sheet,  re-save the destination workbook in xls format.

===

Regards,

Norman

Answer 2

Hi Jennifer,

Thank you, Norman!

You are very welcome.

In order to close this thread, and to assist others who may search the forum archives for a solution to a similar problem, I would ask you kindly to mark my response as Answer.

===

Regards,

Norman