I have a spreadsheet with multiple tables. If I copy rows of data from another area and try to insert the data into the table, I get this message:
This operation is not allowed. The operation is attempting to shift cells
in a table on your worksheet.
If I insert less rows then what is between the tables is fine. Everything shifts down. If the number of rows exceeds the number of rows between the tables I get the message.