EXCEL CANNOT INSERT THE SHEET INTO DESTINATION WORKBOOK BECAUSE ITS CONTAINS FEWER ROWS

Excel cannot insert the sheets inkhổng lồ the destination workbook, because it contains fewer rows và columns than the source workbook. To move sầu or copy the data to lớn the destination workbook, you can select the data, và then use Copy and Paste commands lớn insert it inlớn the sheets of anotherworkbook.

Bạn đang xem: Excel cannot insert the sheet into destination workbook because its contains fewer rows


So that everyone can use my Excel Charts & Dashboard Templates, I typically save my files in an Excel 97-2003 format. There are other good benefits of this file type, but we can talk about that on another day. Since most of my files are in the 2003 format, it sometimes causes me problems when I work between 2003 and Excel 2007, 2010 or now Excel 2013 format. Here is an error that I recently received.

Xem thêm: Cách Kẻ Bảng Trong Excel 2013 Nhanh Chóng, Cách Tạo Bảng Excel, Chèn Bảng Trong Excel


 I was I trying khổng lồ move sầu or copy a worksheet from one workbook lớn another workbook. You can bởi vì this by right clicking on the worksheet tab you want khổng lồ move/copy:
*
*

Now my I forgot that the destination file was in this older format (Excel 97-2003) và I got the following error:
*

“Excel cannot insert the sheets inlớn the destination workbook, because it contains fewer rows và columns than the source workbook. To move sầu or copy the data lớn the destination workbook, you can select the data, và then use the Copy & Paste commands to insert it inkhổng lồ the sheets of another workbook.”
Hmmmilimet, that is not good. Sometimes you don’t want khổng lồ copy and paste the data. For instance, check out this post on why you would want to lớn copy or move the worksheet when you are working with Excel charts:
Based on the error, it looks like I need lớn change the Excel workbook khổng lồ the new Excel 2007 or greater format.
Likewise, the new Excel 2013 format has over 1 million rows in the spreadsheet
*

và the previous Excel 2003 format only has 65,000.
*

*