I get an error message while copying worksheets between workbooks

C

CRACARCONSTRUCTION

I AM TRYING TO COPY WORKSHEETS BETWEEN TWO DIFFERENT WORKBOOKS BUT I GET THE
MESSAGE "EXCEL CANNOT INSERT THE SHEETS INTO THE DESTINATION WORKBOOK,
BECAUSE IT CONTAINS FEWER ROWS AND COLUMNS THAN THE SOURCE WORKBOOK. TO MOVE
OR COPY THE DATA TO THE DESTINATION WORKBOOK, YOU CAN SELECT THE DATA, AND
THEN USE THE COPY AND PASTE COMMANDS TO INSERT IT INTO THE SHEETS \OF ANOTHER
WORKBOOK." IN OFFICE 97-2003 THIS WAS A STANDARD OPERATION BUT I CAN'T GET IT
TO WORK IN '07.
 
S

Shane Devenshire

TYPING IN CAPS is CONSIDERED shouting SHOUTING.

Are you trying to copy a 2007 sheet into 2003. If so copy a range not the
whole sheet. 2003 has 256 columns and 65,536 rows, 2007 has a whole lot
more. You can't put an elephant in a mouse cage.
 

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

Create a dynamic master file 1
Sharing workbooks limitations - Merged Cells 12
Copy or Move a spreadsheet 1
Linking worksheets in different workbooks 0
Linking workbooks together 1
Copy sheet to different workbook sizing error message 2
Move/Copy sheet to another workbook error 2
move a worksheet from one workbook to another 1

Top