Forum Discussion
Message: "This won't work because it would move cells in a table on your worksheet."
Hello All, I have an issue with Power Query refresh of a table „prev_W_NEE_snapshot_manual_input__8“ located in sheet “NEE_manual“. If I try refresh this table, message "This won't work because i...
OlegC2450 I haven't had a chance to look at your file in detail, but in troubleshooting this error today, I found that if the .add activity needs to move non-table data, including formatting, data validation, etc., it won't work.
Interestingly enough, It also won't work if I had a table with more columns below the table being added to.
i.e.
3 Tables:
A with 8 columns
B with 5 columns
C with 3 columns
If they are stacked on the worksheet in that order, I can .add a row in all 3 tables without a problem.
However
If they are stacked B, A, C then I will get the error on B, but not A or C.
if they are stacked B, C, A then I will get the error on B and C