Forum Discussion

Copper Contributor

Nov 06, 2019

Can't Add Worksheet and/or Move/Copy Worksheet in Excel File

All of a sudden, I cannot add a worksheet or move/copy a worksheet within an excel file I have been working with. The file is shared with other co-workers. I can complete this function in other fil...

excel

Nik_B4000

Copper Contributor

Aug 13, 2021

Val_L

I had the same issue now (August 2021) but could solve it.

It turned out that it was a format issue of the Excel sheet.

".xlsx" vs. ".xls" ("Excel Worksheet" against "Excel 97-2003 Worksheet").

Both worksheets need to have the same format in order to copy or move sheets properly.