Fix Excel 2019 ActiveX Controls and VBA Forms on a Second Monitor
Question details
Resolve ActiveX controls or VBA UserForms that fail when an Excel 2019 workbook is opened on a secondary monitor.

- Product
- Microsoft Excel 2019
- Device & OS
- not provided
- Scenario
- A workbook is opened on a second display after an upgrade from 32-bit Excel 2010 to 64-bit Excel 2019.
- Observed behavior
- Controls or forms may fail when Excel starts on the secondary display, although they work when Excel starts on the primary display.
Check whether the workbook works when Excel starts on the primary monitor, then test it after moving the Excel window to the second monitor. Note the display scaling settings and confirm the installed Excel version under File > Account > About Excel.
Start Excel on the Primary Monitor and Test Display Scaling
Use this workaround when the controls work after Excel starts on the primary display but fail when it starts on the second display.
Close Excel, start it on the primary monitor, and open the affected workbook. Test the ActiveX controls or UserForm before moving the window.
Drag the Excel window to the second monitor and test the same controls or form again. If they work, start Excel on the primary monitor as a temporary workaround.
On Windows, open Settings > System > Display, select each monitor, and check its Scale setting. Try matching the scaling values temporarily, then restart Excel and retest.
If available, open Excel's File > Options > General and select Optimize for compatibility under User Interface options. Restart Excel and test the workbook on the second monitor.

Update Office and Check 64-Bit VBA Compatibility
Use these checks after upgrading from 32-bit Excel 2010 to 64-bit Excel 2019.
Check for Stale Control Cache Files and Older Office Components
Use this cleanup check if the display and update tests do not resolve the issue.
Work with Excel Files in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for common Microsoft Office formats, making it easier to move everyday documents between suites. It does not fix Excel's ActiveX or VBA display behavior; check your workbook's control and macro requirements before switching.

Frequently Asked Questions
Why do the forms work after I move Excel to the second monitor?
The behavior may depend on where Excel starts or on display scaling. Start Excel on the primary monitor, open the workbook, and then drag the window to the second monitor as a workaround.
How can I check whether Excel is 32-bit or 64-bit?
In Excel, select File > Account > About Excel. The window identifies the installed version and whether it is 32-bit or 64-bit.
What if I cannot find any EXD files?
There may be no relevant cached files to remove. Skip that step and test display scaling, Office updates, and 64-bit compatibility instead.
Can display scaling affect Excel forms?
Different scaling values may contribute to display issues. On Windows, check each monitor under Settings > System > Display, try matching the Scale values, and restart Excel before testing.
Will WPS Office fix Excel ActiveX or VBA form errors?
No. WPS Office is an alternative for common spreadsheet tasks, not a repair for Excel's ActiveX or VBA behavior. Verify support for any macros and controls your workbook requires before relying on it.




