Forum Discussion
Copied a Macro-Enabled Workbook into OneDrive, now macros cannot be run, edited, or deleted.
I assume you added your local Onedrive location.
now you should add the online Onedrive location name "https://d.docs.live.net/" make sure that you checked the "Subfolders of this location are also trusted"box.
Noted that you have to check the "Allow Trusted Locations on my network (not recommended)" box first.
ChristopherLandry Hi Chris, did you end up getting any good solutions? We are having (maybe) similar issues, sadly don't know how to make Excel to trust our personal onedrive folders
zfeng1380 Hello. Unfortunately Microsoft has been completely silent about this issue as far as I'm aware.
Here's a more complete image than the one I put in my original article showing how to get to the Trusted Locations settings in Excel Options for adding a local folder to the Trusted Locations list.
If you get to this point and your Excel workbook's macros continue to work after the workbook is added to a OneDrive folder, please let me know. Maybe Microsoft has fixed this in the background with an update somewhere along the way.
ChristopherLandry thanks for the detailed reply. Unfortunately no luck still. Life is so tough using 2 office products....
