VBA & Macro Problems

Does OneDrive Delete Macros from Excel Workbooks? How to Fix

Camila Milosovich Oct 8, 2026 870 views

Question details

The user wants to know if OneDrive automatically deletes VBA macros and how to recover them when they appear missing after saving and syncing.

Does OneDrive Delete Macros from Excel Workbooks?

Product: Microsoft Excel, OneDrive
Device & OS: not provided
Scenario: Saving an Excel workbook containing VBA macros to a local desktop folder that is synchronized with OneDrive.
Observed behavior: Macros appear to be completely removed or missing from both the local desktop copy and the OneDrive cloud copy after the file is saved.

Before you start

Verify your OneDrive synchronization status to ensure no sync errors are occurring, and check your Excel Trust Center settings to confirm that macro execution is allowed.

Solution 1Recommended

Verify File Format and Check VBA Modules

Ensure the workbook is saved correctly as a Macro-Enabled Workbook (.xlsm) and use the Visual Basic Editor to confirm the presence of your macros.

OneDrive does not actively delete VBA macros from files. The most common reason macros disappear is that the workbook was accidentally saved in the default Excel Workbook (.xlsx) format, which automatically strips all VBA code to prevent macro-based malware.

Check the file extension

Right-click your Excel file in your local OneDrive folder, select Properties, and ensure the file format is '.xlsm' (Excel Macro-Enabled Workbook) rather than the standard '.xlsx'.

Open the Visual Basic Editor

Open the affected workbook in Excel and press 'Alt + F11' on your keyboard to launch the Visual Basic for Applications (VBA) Editor.

Verify macro modules

In the Project Explorer pane on the left side of the VBA Editor, expand the 'Modules' folder to see if your macro code is still present.

Save as Macro-Enabled

If you are recovering from a backup, go to File > Save As, and explicitly select 'Excel Macro-Enabled Workbook (*.xlsm)' from the dropdown menu before saving it to OneDrive.

Verify File Format and Check VBA Modules

Test with a Local Copy: Copy the file to a completely local folder (like Documents, outside of OneDrive) to test whether the macros remain intact when saved locally.

Solution 2

Restore Previous Versions from OneDrive

If the macros were accidentally overwritten or stripped due to being saved in the wrong format, you can restore a previous working version directly from OneDrive.

Free Microsoft Office alternative

Manage Macro-Enabled Spreadsheets Seamlessly with WPS Office

If you are experiencing macro deletion or sync issues in Microsoft Excel, consider switching to WPS Office. It provides a lightweight, highly compatible environment for your VBA macros and standard spreadsheets without unexpected file modifications.

1. Download and Install: Visit the official WPS Office website to download the free suite and follow the simple installation prompts.
2. Open Your Spreadsheet: Launch WPS Spreadsheet and click 'Open' to browse for your .xlsm file.
3. Enable and Run Macros: WPS Office will recognize your VBA code. Simply enable macros when prompted and press Alt+F11 to access the familiar VBA Editor.

Fully compatible with Microsoft Excel formats, including .xlsx and .xlsm files.Robust VBA and Macro support for automating complex spreadsheet tasks.Free, lightweight, and fast, offering a familiar user interface that requires no learning curve.Seamless local and cloud saving options that respect your original file extensions.

microsoft office alternative - wps office

Frequently Asked Questions

Why did my macros disappear after saving to OneDrive?

Macros typically disappear if the workbook is accidentally saved as a standard Excel Workbook (.xlsx) instead of a Macro-Enabled Workbook (.xlsm). The standard format strips all VBA code from the file upon saving.

Does OneDrive block macro-enabled files for security reasons?

No, OneDrive itself does not block or delete macros; it simply stores and syncs your files. However, Microsoft's 'Mark of the Web' security feature might block macros from running on files opened from a synchronized cloud location until you unblock them in the file properties.

How can I prevent losing my Excel macros in the future?

Always ensure you actively select 'Excel Macro-Enabled Workbook (*.xlsm)' from the 'Save as type' dropdown menu when saving a new file. Additionally, keep a local backup copy of complex VBA projects outside of your main sync folder.

Can a sync conflict cause macro deletion?

While rare, if a sync conflict occurs and OneDrive creates a duplicate 'conflict' file, it might default to a state without macros if the file extension was mishandled during the overwrite. Always check both the original and the conflict copy.

Excel & Data Problems