Table - error?

%3CLINGO-SUB%20id%3D%22lingo-sub-2094155%22%20slang%3D%22en-US%22%3ETable%20-%20error%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2094155%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All!%26nbsp%3B%20I%20get%20an%20error%20in%20some%20of%20my%20excel%20tables%20when%20i%20try%20and%20%22Insert%22%20a%20%22row%22%20(that's%20the%20steps%20..%20right%20click%2C%20insert%2C%20row.)%26nbsp%3B%20Error%20is%20below.%26nbsp%3B%20Anybody%20know%20why%20this%20would%20happen%3F%26nbsp%3B%20It's%20random%20-%20some%20tables%20allow%20me%20to%20insert%2C%20others%20don't.%26nbsp%3B%20When%20they%20don't%2C%20i%20have%20to%20insert%20a%20row%20into%20the%20spreadsheet%20overall%20vs.%20just%20a%20row%20in%20the%20table.%26nbsp%3B%20I%20thought%20one%20of%20the%20benefits%20of%20a%20table%20is%20you%20can%20add%20or%20remove%20rows%20without%20impacting%20anything%20else%20on%20your%20spreadsheet!%26nbsp%3B%20Thank%20you!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22leanne_michels_0-1611438305203.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F248904iAF19FB79F8798005%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22leanne_michels_0-1611438305203.png%22%20alt%3D%22leanne_michels_0-1611438305203.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2094155%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Hi All!  I get an error in some of my excel tables when i try and "Insert" a "row" (that's the steps .. right click, insert, row.)  Error is below.  Anybody know why this would happen?  It's random - some tables allow me to insert, others don't.  When they don't, i have to insert a row into the spreadsheet overall vs. just a row in the table.  I thought one of the benefits of a table is you can add or remove rows without impacting anything else on your spreadsheet!  Thank you!

 

leanne_michels_0-1611438305203.png

 

1 Reply

@leanne_michels 

Most probably you have another table to the right or to the left of this one. Try to right click on the cell within the table and use Insert from right click menu (if you inserted entire row here).