May 16 2023 01:36 PM
Hello
I built a financial simulator in a workbook using 5 sheets interrelated with formulas, etc. The sheets are embedded.
I need to duplicate those 5 sheets at once in the same workbook (like to have 2 simulators in the same workbook) but I can't because it says "you cannot copy or move a group of sheets that contain a table". Do you have a solution ?
Thank you in advance
May 16 2023 01:42 PM
This is a limitation of Excel.
If a worksheet contains at least one table, you'll have to copy (duplicate) it by itself. As the error message indicates, it is impossible to copy such a sheet if it is grouped with other sheets.
May 16 2023 02:45 PM