can no longer paste into a separate workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-1298870%22%20slang%3D%22en-US%22%3Ecan%20no%20longer%20paste%20into%20a%20separate%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1298870%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20very%20large%20workbook%20that%20I%20have%20to%20copy%20parts%20of%20into%20a%20separate%20workbook%20a%20couple%20times%20a%20month.%26nbsp%3B%20This%20has%20always%20worked%20with%20copying%20a%20range%20in%20the%20source%20workbook%20then%20selecting%20one%20cell%20in%20the%20destination%20workbook%20and%20'paste.'%26nbsp%3B%20However%2C%20now%20when%20i%20try%20to%20click%20in%20one%20cell%20in%20the%20new%20workbook%20and%20paste%2C%20i%20get%20the%20following%20error%20message%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can't%20paste%20this%20here%20because%20the%20copy%20area%20and%20paste%20area%20are%20not%20the%20same%20size.%3C%2FP%3E%3CP%3ESelect%20just%20one%20cell%20in%20the%20paste%20area%20or%20an%20area%20that's%20the%20same%20size%2C%20and%20try%20pasting%20again.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1298870%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1299424%22%20slang%3D%22en-US%22%3ERe%3A%20can%20no%20longer%20paste%20into%20a%20separate%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1299424%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F617400%22%20target%3D%22_blank%22%3E%40psatterfield%3C%2FA%3E%26nbsp%3BI%20suspect%20that%20you%20are%20trying%20to%20copy%20entire%20rows%20and%2For%20columns%20and%2C%20perhaps%20accidentally%2C%20try%20to%20paste%20these%20into%20a%20cell%20that%20is%20%3CSTRONG%3Enot%3C%2FSTRONG%3E%20in%20column%20A%20(for%20rows)%20or%20in%20row%201%20(for%20columns).%3C%2FP%3E%3CP%3EFor%20example%2C%20when%20you%20try%20to%20copy%20rows%2010%3A100%20and%20paste%20to%20B1%2C%20the%20the%20error%20message%20comes%20up.%20The%20same%20happens%20when%20you%20try%20to%20copy%20columns%20G%3AP%20and%20paste%20to%20A2.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20this%20is%20not%20the%20case%2C%20can%20you%20give%20an%20example%20of%20a%20non-working%20copy%2Fpaste%20action%2C%20indicating%20the%20range%20you%20copy%20from%20and%20the%20cell%20reference%20you%20try%20to%20paste%20to%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I have a very large workbook that I have to copy parts of into a separate workbook a couple times a month.  This has always worked with copying a range in the source workbook then selecting one cell in the destination workbook and 'paste.'  However, now when i try to click in one cell in the new workbook and paste, i get the following error message:

 

You can't paste this here because the copy area and paste area are not the same size.

Select just one cell in the paste area or an area that's the same size, and try pasting again.

 

Please help!!

 

1 Reply
Highlighted

@psatterfield I suspect that you are trying to copy entire rows and/or columns and, perhaps accidentally, try to paste these into a cell that is not in column A (for rows) or in row 1 (for columns).

For example, when you try to copy rows 10:100 and paste to B1, the the error message comes up. The same happens when you try to copy columns G:P and paste to A2.

 

If this is not the case, can you give an example of a non-working copy/paste action, indicating the range you copy from and the cell reference you try to paste to?