Excel always shows SharePoint URL in ActiveWorkbook.Path even when OneDrive is closed. Sync seems broken since Oct 9.

Question

Hi everyone,

Before Oct 9, whenever I closed OneDrive on my PC, Excel would open the local version of the file and ActiveWorkbook.Path would show a normal local path such as C:\Users\...\OneDrive - Company\....

However, since Oct 9, I closed OneDrive on my PC, but the activeworkbook.path becomes a URL:http://xxxxx. instead of local path.

If anyone has suggestions or has experienced this issue, I’d really appreciate the help.

Thank you

Answer 1

It seems that the issue you are experiencing with Excel showing a SharePoint URL in ActiveWorkbook.Path instead of a local path may be related to the changes in coauthoring capabilities for OneDrive-synced files that were implemented starting in the October 2019 update for Microsoft 365. Since that update, locally synced Office files no longer allow coauthoring when opened from the OneDrive for Business sync client, which might affect how Excel handles file paths when OneDrive is closed.

When OneDrive is not running, Excel may default to accessing the SharePoint version of the file instead of the local copy, leading to the behavior you're observing. This could be a result of how Excel is configured to handle file locations when OneDrive is not active.

To troubleshoot this issue, you might consider the following steps:

1. Ensure that your OneDrive sync client is updated to the latest version.
2. Check your Excel settings to see if there are any configurations related to file paths or saving that could be adjusted.
3. If the problem persists, consider reinstalling the OneDrive sync client to reset any settings that may be causing this behavior.

If none of these steps resolve the issue, you may want to reach out to Microsoft support for further assistance.

Answer 2

Hi @Sandy, 

Thank you for posting your question in the Microsoft Q&A forum. 

I understand that the Excel file path is showing as a SharePoint URL instead of a local path, even when OneDrive is closed. To assist you better, I’d like to clarify a few details: 

1. Does this issue occur with all Excel files or only specific ones? 
2. Are the files showing the URL path stored in a OneDrive sync folder? 
3. Is the ActiveWorkbook.Path being used in a VBA module, or is it for another purpose? 

If this is related to VBA, you might try using: 

GetLocalPath(ThisWorkbook.FullName)  

and check whether this resolves the issue for your code. 

For additional reference, you can review this discussion:  Excel's FullName property with OneDrive – Stack Overflow 

Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link   

Thank you again for your time and understanding. While my initial response may not resolve the issue immediately, I’d like to gather more details about your situation so I can assist you more effectively.      

I really appreciate your patience, and I’m here to help. Looking forward to your response!      

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".   

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.