Forum Discussion
Getting this message: "This won't work because it would move cells in a table on your worksheet."
laura_protzman this may not apply to your situation but it's what created that error for me:
I have a MS Power Automate Flow that would check the contents of an excel table and delete rows in the table. Everything worked fine until today I get that error. In the end I discovered it's because the last time I used the file I left that table filtered based on a column entry. Once I turned off the filter and saved it the Flow work again.
I have had the same problem but my problem was that I created a table, I didn't even realise I did, selecting a few columns (usually selected to the end of the worksheet). So when I tried to add a row, it was imposible because I already had maximum rows. Don't know how I realised that but problem was fixed by deleting the unused rows, creating more space to add them back in (anywhere you want).
- Oh my goodness - four years later but this saved me a real headache ! Thank you..
