Fix Excel Upload and Merge Errors After Adding ActiveX Text Boxes
Question details
Users are experiencing merge and upload errors in a shared macro-enabled workbook after replacing standard text boxes with ActiveX controls.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Collaborating on a shared macro-enabled workbook that contains newly added ActiveX controls.
- Observed behavior
- The workbook fails to upload or merge properly, particularly when collaborators access the file via Excel for the web or when ActiveX conflicts with workbook sharing features.
Before modifying the workbook or deleting controls, ensure that all collaborators have saved their work and created a local backup copy of the file to prevent accidental data loss during troubleshooting.
Force the Workbook to Open in Desktop Excel
Excel for the web has limited support for ActiveX controls, which can trigger compatibility and merge errors. Opening the file exclusively in the desktop app avoids this conflict.
ActiveX controls are legacy desktop components that do not function in browser-based environments. When multiple users co-author a file using different platforms (web vs. desktop), sync conflicts are highly likely.
Open the SharePoint or OneDrive folder where the macro-enabled workbook is hosted.
Right-click the file, select 'Open', and choose 'Open in Desktop App' instead of opening it in the browser.
Ensure that every user who needs to edit the workbook is exclusively opening it via the desktop version of Excel.
Temporarily Remove ActiveX Controls
Removing the suspected ActiveX controls allows you to determine if they are the direct cause of the workbook sharing failure.
Update Windows and Excel
Outdated software can cause unexpected co-authoring and macro compatibility issues. Ensuring your system is up to date may patch known sync bugs.
Use WPS Office for Seamless Macro and Form Compatibility
If legacy ActiveX controls and workbook sharing continue to cause merge errors in Microsoft Excel, consider switching to WPS Office. It is a free, lightweight alternative that offers excellent compatibility with Excel macro-enabled workbooks (.xlsm) and standard form controls, providing a stable environment for your data without sync conflicts.
- 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
- 2. Open your workbook: Launch WPS Spreadsheet and open your existing macro-enabled (.xlsm) file.
- 3. Use stable controls: Insert standard form controls via the Developer tab for a crash-free experience.

Frequently Asked Questions
Why do ActiveX controls cause merge errors in shared workbooks?
ActiveX controls are older, desktop-bound components that are not fully supported in modern co-authoring environments or Excel for the web. When multiple users try to sync a file containing them, Excel struggles to merge the object states, leading to upload conflicts.
Can I use ActiveX controls in Excel for the web?
No, Excel for the web does not support running, editing, or interacting with ActiveX controls. Attempting to do so can trigger compatibility warnings or prevent the file from saving properly.
What is the best alternative to ActiveX text boxes?
You should use standard Form Controls (found under the Developer tab > Insert > Form Controls). They are much more stable, widely supported across all modern Excel versions, and significantly less prone to causing sharing and merge errors.




