'%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)
Fix Excel Cannot Open XLSM File in OneDrive Trusted Location
Question details
Users are unable to open macro-enabled XLSM workbooks stored in a OneDrive Trusted Location using Microsoft Excel.
- Product
- Microsoft Excel, OneDrive
- Device & OS
- not provided
- Scenario
- Attempting to open shared or personal macro-enabled workbooks hosted on a OneDrive network path.
- Observed behavior
- Excel fails to open the XLSM file entirely, or fails to open it when macros are enabled, often due to an incorrectly configured d.docs.live.net path or a OneDrive account mismatch.
Verify you are signed into the correct Microsoft account associated with the OneDrive folder, and test downloading the file to your local computer to ensure the XLSM file is not corrupted.
Recreate the OneDrive Trusted Location in Excel
Update the trusted location settings in Excel to ensure the OneDrive URL and the d.docs.live.net path are mapped to the correct user account.
If a previously used docs.live.net path was altered or belongs to another account that shared the file, Excel's Trust Center will block the macro-enabled workbook. Deleting and recreating this path ensures Excel is using the proper network routing.
Open Excel and click on 'File' > 'Options'. Navigate to 'Trust Center' and click 'Trust Center Settings'. Select 'Trusted Locations', find the problematic OneDrive path in the list, and click 'Remove'.
Log into OneDrive on your web browser. Navigate to the exact folder containing your XLSM file and copy the URL from the address bar (or copy the direct sharing link provided by the owner).
Return to the Excel Trusted Locations window and click 'Add new location'. Paste the copied OneDrive URL into the path field, check the box for 'Subfolders of this location are also trusted', and click 'OK'.
Contact Microsoft OneDrive Support for Path Resolution
If the file opens normally when macros are disabled but fails completely when they are enabled, you may need to escalate the server pathing issue to Microsoft Support.
Open Macro-Enabled Spreadsheets Easily with WPS Office
If Excel's strict Trust Center and OneDrive network path issues are preventing you from accessing your work, switch to WPS Office. It provides a lightweight, hassle-free environment to view, edit, and manage your spreadsheets.
- 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
- 2. Save the XLSM file locally: Download your problematic XLSM file from OneDrive directly to your computer's local hard drive.
- 3. Open and edit seamlessly: Open the file using WPS Spreadsheet to start viewing and editing your data instantly without cloud path errors.
Frequently Asked Questions
Why does my XLSM file open without macros but fails when macros are enabled?
This occurs because Excel's Trust Center actively blocks macro execution from cloud or network paths (like OneDrive) if the exact server address isn't properly registered and verified in the Trusted Locations list.
What is the d.docs.live.net path in Excel?
It is a network path protocol used by Microsoft Office to map personal OneDrive cloud storage directly to your Windows File Explorer and Office applications, enabling seamless real-time file access.
How can I quickly bypass OneDrive Trusted Location errors?
You can bypass cloud network path errors by downloading the XLSM file directly to a local folder on your computer (such as your Desktop or Documents), and then adding that local folder to Excel's Trusted Locations.
