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

Excel cannot insert the sheets into lớ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, and then use Copy và Paste commands khổng lồ insert it inkhổng lồ the sheets of anotherworkbook.

Bạn đang xem: Excel cannot insert the sheets into the destination workbook, because it contains fewer rows and columns than the source workbook


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 tệp tin 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 & Excel 2007, 2010 or now Excel 2013 format. Here is an error that I recently received.

Xem thêm: Hướng Dẫn Cách Tách Cột Họ Và Tên Trong Excel 6/2021, Tách Họ Và Tên Trong Excel


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

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

“Excel cannot insert the sheets inkhổng lồ the destination workbook, because it contains fewer rows & columns than the source workbook. To move sầu or copy the data to the destination workbook, you can select the data, & then use the Copy and Paste commands to insert it inlớn the sheets of another workbook.”
Hmmmilimet, that is not good. Sometimes you don’t want to lớn copy and paste the data. For instance, kiểm tra out this post on why you would want lớn copy or move sầu the worksheet when you are working with Excel charts:
Based on the error, it looks lượt thích I need khổng lồ change the Excel workbook to lớn the new Excel 2007 or greater format.

Xem thêm: Tô Màu Theo Điều Kiện Trong Excel, Cách Tô Màu Có Điều Kiện Trong Excel Nhanh Nhất


Likewise, the new Excel 2013 format has over 1 million rows in the spreadsheet
*

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

*


Chuyên mục: Review thủ thuật