|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Copy unique worksheet to another workbook refuses says columns rows differ
Hi, Excel 2013
I am following one methods to take a worksheet that exists in workbook 1 across to workbook 2 WHERE IT DOESNT EXIST. it refuses, so I try another method, again same refusal. Method 1 drag and drop with ctrl held down, get an insertion point and release. Method 2 right click the sheet and choose the destination workbook from a drop down list, choose the before or after existing sheet for the destination, click copy box, ok it. Both these methods fail, they declare unable to do so as 'it contains fewer rows and columns' ot says, it then goes on to say to do so use copy paste into the existing sheet ! THERE IS NO EXISTING SHEET, thats why I want to copy the sheet not whats within it ! I am not copying into a sheet, I am copying a sheet that only exists in workbook 1 over to workbook 2 so it shouldnt even be counting rows and columns at all, ! Help ! DBenz |
#2
|
|||
|
|||
|
#3
|
|||
|
|||
This generally happens when one workbook is in the .xlsx format, and the other is in .xls. I've had it happen after converting to the latest version, but I suspect if I took the time to close the program and re-open it it would work. My path of least resistance solution is if I can't move sheet X into workbook Y, I move all the sheets of Y into X, and that usually works.
Since you're in Excel 2013, it may be a different incompatibilty, but try that. Before .xlsx there were 65,536 maximum rows per worksheet. In the current version there are 1,048,576 rows. Thus the error message. If one of your sheets says it's in Compatibility Mode at the top of the title bar, that's a clue it's in a different format. |
#4
|
|||
|
|||
Follow up: I can confirm that this just happened again when I converted an .xls workbook to .xlsx, and then tried to slide the sheet in, it still wouldn't go. However, closing and re-opening the converted workbook, it then worked fine. I guess it just needs that refresh.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How can I copy a worksheet and paste values to another new workbook ? | DBenz | Excel | 1 | 01-26-2019 07:03 AM |
PPT 2016 refuses to copy/reuse slides from one pres. to another! | Pantucci | PowerPoint | 0 | 08-18-2017 06:14 AM |
Looping through rows and copy cell values to another worksheet | get4hari | Excel Programming | 1 | 10-02-2015 04:51 PM |
Copy Multiple Rows to new workbook when multiple criteria is met. | flds | Excel Programming | 5 | 09-30-2014 09:58 AM |
Appending unique data from one worksheet to existing data on another worksheet | EdStockton | Excel | 1 | 08-06-2014 11:00 PM |