move a worksheet from one workbook to another

W

Wizard475

typical select the sheet and move (or copy) to another workbook open in the
same session does not work in Excel 2007.

I get the following error message: "Excel cannot insert the sheets into the
destination workbook, because it contains fewer rows and columns than the
source workbook..." it goes on to recommend a 'copy and paste' approach to
get the data in the new book, which is not efficient.

any thoughts?
 
S

Sheeloo

Looks like the detination is in XLS format (Excel 2003) and the source is in
XLSX (Excel 2007).
Either save the source in Excel 97-2003 format or the detination in Excel
2007 before performing the move.

Or, as suggested by Excel, select the used range in the source sheet, copy
and then paste in the detination. Of course then you should have less than
256 cols and 65K rows in the source.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Move/Copy sheet to another workbook error 2
Merge Multiple workbook sheets into one workbook 0
Copy or Move a spreadsheet 1
I get an error message while copying worksheets between workbooks 1
Copy sheet to different workbook sizing error message 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Templates in Excel 2007 4
Copy from one workbook to another 1

Top