Forum Discussion
Getting this message: "This won't work because it would move cells in a table on your worksheet."
Thank you, this was a great work-around for a stubborn problem. The error message is understandable, but the workarounds are not always so intuitive. So, thank you for the RESIZE option!
Actually, it makes perfect sense that any table change that shifts some, but not all, of another table's cells would be problematic. Just surprised there is no option to add free rows or columns between tables so the operation can be performed if the table is only bringing in vacant cells in vacant rows or columns (and not really expanding into other tables), which is what the resize option technically does to overcome the problem.
Another anomaly is that this message is also displayed even when you are NOT CHANGING the size of the table. For example, when you are moving or repositioning columns, which doesn't change the table dimensions, you are annoyingly prevented from doing so by this message. Presumably, because some cells might be temporarily shifted or displaced in another table during the operation.
It would be nice if Excel was smart enough to, at least, accommodate row and column moves which don't change the table dimensions. This problem creates real nightmares for worksheets with a variety of non-conforming dimensions.