'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Restore ActiveX Controls in Excel After Saving on Mac
Question details
The user needs to recover ActiveX controls in a shared Excel workbook that became unusable after being saved on a Mac and reopened on Windows.
- Product
- Microsoft Excel
- Device & OS
- Mac and Windows
- Scenario
- A shared Excel workbook containing Windows-specific ActiveX controls was edited and saved by a user on a Mac environment.
- Observed behavior
- The ActiveX controls in the workbook break and become entirely unusable for Windows users after the file is saved on a Mac.
Verify whether your shared Excel workbook was saved to a cloud service like OneDrive or SharePoint, as this will dictate if version history recovery is possible.
Recover an Earlier Workbook Version via Cloud Storage
If the file was saved on OneDrive or SharePoint, you can restore a previous version from before the Mac user edited it.
Open SharePoint or OneDrive in your web browser and navigate to the folder containing your affected Excel file.
Right-click the Excel file and select 'Version history' from the context menu to view past saves.
Look at the dates and authors in the version panel to find the last working version saved before the Mac user made their edits.
Click the vertical ellipsis (three dots) next to the target version and select 'Restore' to revert the file to its working state.
Restore the File Using Mac Time Machine
If the file was stored locally on the Mac, you might be able to retrieve an older working version using Time Machine backups.
Replace ActiveX Controls with Standard Excel Form Controls
Because ActiveX controls are unsupported on Mac and disabled by default in newer Excel for Windows versions, replacing them ensures long-term cross-platform compatibility.
Use WPS Office for Seamless Cross-Platform Collaboration
ActiveX compatibility issues between Mac and Windows can disrupt your workflow. WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office, ensuring your spreadsheets, formulas, and standard controls work flawlessly across Windows, Mac, and Linux environments without formatting loss.
- 1. Download and Install: Visit the official WPS Office website to download and install the software for your operating system.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing .xlsx or .xls files directly with full formatting retained.
- 3. Collaborate Across Platforms: Share your spreadsheets easily with Mac or Windows users, knowing standard controls and formulas will remain intact.
Frequently Asked Questions
Why do ActiveX controls stop working after editing an Excel file on a Mac?
ActiveX is a proprietary Microsoft Windows technology, and Mac operating systems do not support it. When a Mac user opens and saves an Excel file containing ActiveX controls, those controls can be corrupted or stripped out, rendering them unusable when the file is reopened on a Windows computer.
Are ActiveX controls supported in modern versions of Excel for Windows?
In newer versions of Excel for Windows, ActiveX controls are often disabled by default due to strict security protocols. Microsoft increasingly recommends using standard Form Controls instead for better security and cross-platform compatibility.
Can I still use macros in Excel for Mac if I remove ActiveX?
Yes, Excel for Mac fully supports standard VBA (Visual Basic for Applications) macros. However, any macro code that specifically calls Windows-only libraries or attempts to interact with ActiveX controls will not execute on a Mac.
