VBA & Macro Problems

How to Enable Personal Macros for Shared Excel Workbooks

Huma Ashraf Ch Oct 1, 2026 869 views

Question details

Personal macros stored in the XLSTART folder do not load automatically when opening shared workbooks from a network drive.

How to Enable Personal Macros for Shared Excel Workbooks

Product: Excel
Device & OS: not provided
Scenario: Opening shared workbooks from an organization's network drive while needing personal macros to run automatically.
Observed behavior: Excel macros fail to load or run automatically from the XLSTART folder due to security restrictions placed on shared network locations.

Before you start

Verify the exact network path of your shared workbook and ensure that the shared drive is securely managed by your organization's IT department to avoid malicious macro risks.

Solution 1Recommended

Add the Shared Location to Excel's Trusted Locations

Configuring Excel's Trust Center to accept network drives allows shared workbooks and personal macros to load without security blocks.

By default, Excel treats network locations as unsafe. To run macros automatically from a shared drive, you must explicitly declare the network path as a Trusted Location in the Trust Center.

Open Trust Center Settings

Launch Excel, click on 'File' in the top-left corner, select 'Options', and navigate to 'Trust Center' at the bottom of the left menu. Click the 'Trust Center Settings' button.

Allow Network Locations

In the Trust Center window, select 'Trusted Locations' from the left pane and check the box at the bottom labeled 'Allow Trusted Locations on my network (not recommended)'.

Add the New Location

Click the 'Add new location' button. Browse to or type in the exact file path of your organization's shared drive where the workbooks are stored.

Include Subfolders and Apply

Check the box for 'Subfolders of this location are also trusted' if necessary, then click 'OK' on all dialog boxes to save your changes and restart Excel.

Add the Shared Location to Excel's Trusted Locations

Security Warning: Only enable network trusted locations if you are certain the shared drive is strictly monitored and protected by your organization.

Solution 2

Add the Shared Drive to Windows Trusted Sites

Adjusting your Windows Internet Options to trust the local intranet or specific network paths can resolve underlying Windows security blocks on macros.

Free Microsoft Office alternative

Manage Spreadsheets and Macros Seamlessly with WPS Office

If you are constantly struggling with complex macro security and Trusted Location settings in Microsoft Excel, consider switching to WPS Office. It offers a secure, lightweight, and highly compatible environment for your daily spreadsheet and macro tasks.

1. Download the Installer: Visit the official WPS Office website and download the free installer for your operating system.
2. Install the Software: Run the setup file and follow the on-screen instructions to complete the installation.
3. Open Macro-Enabled Files: Launch WPS Spreadsheet and easily open your existing .xlsm files to continue your work without hassle.

Excellent compatibility with Microsoft Excel formats, including .xlsx, .xls, and macro-enabled .xlsm files.Reliable macro support for executing automated tasks smoothly across shared and local environments.Free and lightweight software that ensures rapid startup and seamless file migration.Familiar, intuitive user interface that requires zero learning curve for traditional Office users.

Frequently Asked Questions

Why do my personal macros work in local files but not in shared network workbooks?

By default, Microsoft Office treats network drives and internet locations as untrusted to prevent malicious code from executing. Personal macros will be blocked unless you manually add the shared network location to Excel's Trusted Locations.

Where is the XLSTART folder located?

The XLSTART folder is typically found at 'C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Excel\XLSTART'. Any macro-enabled workbook or template placed in this folder is designed to open automatically when you launch Excel.

Does allowing trusted locations on my network pose a security risk?

Yes, it can be risky if the network is public, unmonitored, or compromised. You should only enable this setting and trust specific network folders if the drive is strictly controlled and secured by your company's IT administrators.

Excel & Data Problems