Home

Getting this message: "This won't work because it would move cells in a table on your worksheet."

%3CLINGO-SUB%20id%3D%22lingo-sub-309739%22%20slang%3D%22en-US%22%3EGetting%20this%20message%3A%20%22This%20won't%20work%20because%20it%20would%20move%20cells%20in%20a%20table%20on%20your%20worksheet.%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-309739%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20try%20to%20insert%20a%20row%20in%20a%20formatted%20table%2C%20I%20get%20the%20following%20message%3A%20%22This%20won't%20work%20because%20it%20would%20move%20cells%20in%20a%20table%20on%20your%20worksheet.%22%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-309739%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-310182%22%20slang%3D%22en-US%22%3ERe%3A%20Getting%20this%20message%3A%20%22This%20won't%20work%20because%20it%20would%20move%20cells%20in%20a%20table%20on%20your%20works%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-310182%22%20slang%3D%22en-US%22%3EYes%2C%20it%E2%80%99s%20essentially%20inserting%20cells%20for%20the%20row%20of%20the%20table%20so%20if%20that%20moves%20the%20whole%20lower%20table%20it%E2%80%99s%20fine%20but%20if%20it%E2%80%99s%20just%20part%20of%20the%20table%20that%E2%80%99s%20not%20possible%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-310132%22%20slang%3D%22en-US%22%3ERe%3A%20Getting%20this%20message%3A%20%22This%20won't%20work%20because%20it%20would%20move%20cells%20in%20a%20table%20on%20your%20works%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-310132%22%20slang%3D%22en-US%22%3E%3CP%3EWhat%20is%20interesting%2C%20if%20another%20table%20is%20in%20exactly%20the%20same%20columns%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20176px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F64878i340999AC84E6077A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EExcel%20doesn't%20care%20about%20that%20and%20inserts%20rows%20into%20the%20first%20table%20shifting%20everything%20down%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20151px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F64879i2195B7DD5A3A7337%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-310043%22%20slang%3D%22en-US%22%3ERe%3A%20Getting%20this%20message%3A%20%22This%20won't%20work%20because%20it%20would%20move%20cells%20in%20a%20table%20on%20your%20works%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-310043%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F261263%22%20target%3D%22_blank%22%3E%40laura_protzman%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDo%20you%20have%20another%20table%20below%20the%20one%20you%20are%20trying%20to%20insert%20the%20row%20in%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20so%20you%20could%20just%20insert%20a%20sheet%20row%20rather%20than%20a%20table%20row%26nbsp%3B%20(providing%20that%20doesn't%20mess%20anything%20up%20to%20the%20right%20or%20left%20of%20your%20table)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20887px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F64873i4509051D181BB89A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-517885%22%20slang%3D%22en-US%22%3ERe%3A%20Getting%20this%20message%3A%20%22This%20won't%20work%20because%20it%20would%20move%20cells%20in%20a%20table%20on%20your%20works%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-517885%22%20slang%3D%22en-US%22%3EI%20was%20getting%20the%20same%20error%20message%20because%20I%20had%20accidentally%20chosen%20the%20entire%20columns%20to%20be%20part%20of%20the%20table.%20I%20was%20able%20to%20fix%20by%20going%20into%20Design%20%26gt%3B%20Resize%20Table%20and%20selecting%20the%20proper%20range%20of%20data.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-544576%22%20slang%3D%22en-US%22%3ERe%3A%20Getting%20this%20message%3A%20%22This%20won't%20work%20because%20it%20would%20move%20cells%20in%20a%20table%20on%20your%20works%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-544576%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F261263%22%20target%3D%22_blank%22%3E%40laura_protzman%3C%2FA%3E%26nbsp%3BI'm%20getting%20the%20same%20error%20message%20too.%20I%20can%20insert%20a%20row%20easily%20but%20I%20can't%20'Insert%20Copied%20Cells'%20which%20I%20do%20all%20the%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERead%20through%20the%20other%20comments%20and%20they%20don't%20help%20unfortunately.%20Any%20other%20suggestions%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-544578%22%20slang%3D%22en-US%22%3ERe%3A%20Getting%20this%20message%3A%20%22This%20won't%20work%20because%20it%20would%20move%20cells%20in%20a%20table%20on%20your%20works%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-544578%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F261263%22%20target%3D%22_blank%22%3E%40laura_protzman%3C%2FA%3E%26nbsp%3BPS%20found%20this%20article%20which%20explains%20it%20a%20bit%20more%20but%20still%20doesn't%20give%20an%20answer%20as%20to%20why%20it%20is%20built%20like%20that%3F!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsuperuser.com%2Fquestions%2F417196%2Fcant-insert-cells-in-excel-2010-operation-not-allowed-error-message%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsuperuser.com%2Fquestions%2F417196%2Fcant-insert-cells-in-excel-2010-operation-not-allowed-error-message%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-544734%22%20slang%3D%22en-US%22%3ERe%3A%20Getting%20this%20message%3A%20%22This%20won't%20work%20because%20it%20would%20move%20cells%20in%20a%20table%20on%20your%20works%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-544734%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F337692%22%20target%3D%22_blank%22%3E%40stephen_b78%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAre%20you%20trying%20to%20insert%20copied%20cells%20somewhere%20above%20a%20Table%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EA%20Table%20is%20treated%20as%20an%20entire%20object%20therefore%20inserting%20cells%20above%20a%20table%20tries%20to%20%22push%20down%22%20one%20or%20more%20columns%26nbsp%3B%20in%20the%20table%20which%20can't%20happen%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-652999%22%20slang%3D%22en-US%22%3ERe%3A%20Getting%20this%20message%3A%20%22This%20won't%20work%20because%20it%20would%20move%20cells%20in%20a%20table%20on%20your%20works%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-652999%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F261263%22%20target%3D%22_blank%22%3E%40laura_protzman%3C%2FA%3E%26nbsp%3BI%20had%20a%20similar%20message%20when%20I%20tried%20to%20refresh%20a%20table%20created%20with%20Power%20Query%20based%20on%20reading%20a%20table%20of%20data%20from%20a%20source%20file.%26nbsp%3B%20Turns%20out%20that%20I%20had%20added%20a%20few%20rows%20to%20the%20source%20file%20and%20so%20the%20query%20couldn't%20place%20the%20newly-expanded%20table%20of%20data%20into%20the%20confines%20of%20the%20existing%20table.%26nbsp%3B%20Once%20I%20manually%20added%20rows%20to%20the%20%22receiving%22%20table%20(by%20dragging%20the%20small%2C%20square%20fill%20handle%20in%20the%20lower%20right%20corner%20of%20the%20lower-rightmost%20cell%20in%20the%20table%20down%20to%20add%20as%20many%20rows%20as%20needed)%2C%20the%20query%20was%20able%20to%20run%20again.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-664176%22%20slang%3D%22en-US%22%3ERe%3A%20Getting%20this%20message%3A%20%22This%20won't%20work%20because%20it%20would%20move%20cells%20in%20a%20table%20on%20your%20works%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-664176%22%20slang%3D%22en-US%22%3EThanks%20so%20much%3C%2FLINGO-BODY%3E
laura_protzman
Occasional Visitor

When I try to insert a row in a formatted table, I get the following message: "This won't work because it would move cells in a table on your worksheet."

9 Replies

Hi @laura_protzman

 

Do you have another table below the one you are trying to insert the row in?

 

If so you could just insert a sheet row rather than a table row  (providing that doesn't mess anything up to the right or left of your table)

 

image.png

What is interesting, if another table is in exactly the same columns

image.png

Excel doesn't care about that and inserts rows into the first table shifting everything down

image.png

Yes, it’s essentially inserting cells for the row of the table so if that moves the whole lower table it’s fine but if it’s just part of the table that’s not possible
I was getting the same error message because I had accidentally chosen the entire columns to be part of the table. I was able to fix by going into Design > Resize Table and selecting the proper range of data.

@laura_protzman I'm getting the same error message too. I can insert a row easily but I can't 'Insert Copied Cells' which I do all the time.

 

Read through the other comments and they don't help unfortunately. Any other suggestions?

@laura_protzman PS found this article which explains it a bit more but still doesn't give an answer as to why it is built like that?!

 

https://superuser.com/questions/417196/cant-insert-cells-in-excel-2010-operation-not-allowed-error-m...

@stephen_b78

 

Are you trying to insert copied cells somewhere above a Table?

 

A Table is treated as an entire object therefore inserting cells above a table tries to "push down" one or more columns  in the table which can't happen

@laura_protzman I had a similar message when I tried to refresh a table created with Power Query based on reading a table of data from a source file.  Turns out that I had added a few rows to the source file and so the query couldn't place the newly-expanded table of data into the confines of the existing table.  Once I manually added rows to the "receiving" table (by dragging the small, square fill handle in the lower right corner of the lower-rightmost cell in the table down to add as many rows as needed), the query was able to run again.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
217 Replies