Unable to "Remove Duplicates."

%3CLINGO-SUB%20id%3D%22lingo-sub-3183854%22%20slang%3D%22en-US%22%3EUnable%20to%20%22Remove%20Duplicates.%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3183854%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20tried%20duplicating%20my%20sheet%2C%20it%20says%20%22%3CSPAN%3EThis%20version%20of%20Microsoft%20Excel%20can't%20duplicate%20worksheets%20with%3A%20%E2%80%A2%20ActiveX%20controlsNote%20that%20some%20of%20these%20elements%20may%20be%20hidden%20on%20the%20worksheet%22%2C%20%2Caybe%20ActiveX%20controls%20has%20something%20to%20do%20with%20it%2C%2C%20can%20someone%20please%20tell%20me%20how%20to%20remove%20ActiveX%20controls%20or%20how%20to%20fix%20my%20problem%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThank%20you.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3183854%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3187241%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20%22Remove%20Duplicates.%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3187241%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1311348%22%20target%3D%22_blank%22%3E%40Nebuash%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fwork-with-vba-macros-in-excel-for-the-web-98784ad0-898c-43aa-a1da-4f0fb5014343%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EWork%20with%20VBA%20macros%20in%20Excel%20for%20the%20web%3C%2FA%3E%3C%2FP%3E%3CP%3EYou%20can't%20create%2C%20run%2C%20or%20edit%20VBA%20(Visual%20Basic%20for%20Applications)%20macros%20in%20Excel%20for%20the%20web%2C%20you%20can%20only%20open%20and%20edit%20a%20workbook%20that%20contains%20macros.%20Any%20existing%20macros%20will%20remain%20in%20the%20workbook%2C%20and%20you%20can%20open%20the%20workbook%20in%20the%20Excel%20desktop%20app%20to%20view%20and%20edit%20the%20macros.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fmeet-niko-chatzoudis-excel-forum-contributor%2Fba-p%2F2941385%22%20target%3D%22_blank%22%3ENikolinoDE%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

When I tried duplicating my sheet, it says "This version of Microsoft Excel can't duplicate worksheets with: • ActiveX controlsNote that some of these elements may be hidden on the worksheet", ,aybe ActiveX controls has something to do with it,, can someone please tell me how to remove ActiveX controls or how to fix my problem?

 

Thank you.

1 Reply

@Nebuash 

Work with VBA macros in Excel for the web

You can't create, run, or edit VBA (Visual Basic for Applications) macros in Excel for the web, you can only open and edit a workbook that contains macros. Any existing macros will remain in the workbook, and you can open the workbook in the Excel desktop app to view and edit the macros.

 

Thank you for your understanding and patience

NikolinoDE

I know I don't know anything (Socrates)