Copy Worksheet

G

Guest

When I try to copy a worksheet from one spreadsheet to another, 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 then wants me to copy and paste the data instead.

Any help would be appreciated.
 
P

Peo Sjoblom

Are you using Excel 2007 and you have one spreadsheet created in 2007 format
and another in previous versions format? Then you need to either save a copy
of the workbook as 97-2003 or copy and paste
 
G

Guest

Thanks for the reply. Both are save as 97 -2003 spreadsheets. I can copy a
worksheet from A to B, but not from B to A?
 

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

Excel 2007 Move or Copy worksheet 2
Move or Copy Worksheet 6
Copy sheet to different workbook sizing error message 2
move a worksheet from one workbook to another 1
Works in 2000, not in 2007 4
I get an error message while copying worksheets between workbooks 1
Worksheet copying in Excel 2007 3
Move/Copy sheet to another workbook error 2

Top