Hi!
I have workbooks with multiple worksheets, which are similar in all respects, except that they cover different weeks of the year.
When I group the sheets and attempt to insert a row, I get the message "This operation is not allowed. The operation is attempting to shift cells in a table on your worksheet."
Is there anyway I can remove table formatting across these multiple grouped worksheets so that I would be able to insert a row?
The only alternative is for me to go through each worksheet and insert a row, which would be a terribly tedious process.
The worksheets are not protected, neither do they have any AutoFilter.
Any help would be greatly appreciated.
Thank you very much.
I have workbooks with multiple worksheets, which are similar in all respects, except that they cover different weeks of the year.
When I group the sheets and attempt to insert a row, I get the message "This operation is not allowed. The operation is attempting to shift cells in a table on your worksheet."
Is there anyway I can remove table formatting across these multiple grouped worksheets so that I would be able to insert a row?
The only alternative is for me to go through each worksheet and insert a row, which would be a terribly tedious process.
The worksheets are not protected, neither do they have any AutoFilter.
Any help would be greatly appreciated.
Thank you very much.
