Forum Discussion
Mathieu1975
May 16, 2023Copper Contributor
Duplicate several sheets inside one workbook
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 h...
HansVogelaar
May 16, 2023MVP
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.
Mathieu1975
May 16, 2023Copper Contributor