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.

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.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"CRACARCONSTRUCTION" wrote:

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.