Duplicate several sheets inside one workbook

Copper Contributor

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

2 Replies

@Mathieu1975 

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.

@Hans Vogelaar 

arrgggg

Thank you Hans. I will go sheet by sheet and re-create the links..