Forum Discussion
Co-authoring macro enabled Excel files on a shared OneDrive folder
There are a number of macro enabled Excel files on a personal OneDrive folder shared with me and I am able to co-author a couple of them without the macros getting blocked. There are however quite a...
I seem to have found a workaround.
According to https://learn.microsoft.com/en-us/deployoffice/security/internet-macros-blocked#files-on-onedrive-or-sharepoint one can add the url to your Trusted Sites in "Internet Options". For a personal onedrive, rather than a business one, the URL https://d.docs.live.net worked for me.
In terms of security, one needs to ask if you are willing to have all macros from onedrive run. I guess that was the situation before Sept 22.
According to https://learn.microsoft.com/en-us/deployoffice/security/internet-macros-blocked#files-on-onedrive-or-sharepoint one can add the url to your Trusted Sites in "Internet Options". For a personal onedrive, rather than a business one, the URL https://d.docs.live.net worked for me.
In terms of security, one needs to ask if you are willing to have all macros from onedrive run. I guess that was the situation before Sept 22.
Finally, it is working for me I was, I am searching for this solution very long time. Thank you very much