VBA & Macro Problems

Fix Excel Upload and Merge Errors After Adding ActiveX Text Boxes

Steve KSteve K Oct 9, 2026 871 views

Question details

Users are experiencing merge and upload errors in a shared macro-enabled workbook after replacing standard text boxes with ActiveX controls.

Fix Excel Upload and Merge Errors After Adding ActiveX Text Boxes
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 you start

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.

Solution 1Recommended

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.

1
Navigate to the shared file location

Open the SharePoint or OneDrive folder where the macro-enabled workbook is hosted.

2
Open in Desktop App

Right-click the file, select 'Open', and choose 'Open in Desktop App' instead of opening it in the browser.

3
Coordinate with collaborators

Ensure that every user who needs to edit the workbook is exclusively opening it via the desktop version of Excel.

Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
  2. 2. Open your workbook: Launch WPS Spreadsheet and open your existing macro-enabled (.xlsm) file.
  3. 3. Use stable controls: Insert standard form controls via the Developer tab for a crash-free experience.
Highly compatible with Microsoft Excel formats, including .xlsx and .xlsmSmoothly runs VBA macros and standard form controls without legacy conflictsFree and lightweight alternative to Microsoft OfficeFamiliar user interface for a seamless transition
microsoft office alternative - wps office

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.