Forum Discussion
Issues Enabling Macros in a Shared Excel Workbook on OneDrive
FDOandrade I have been using the same layout (excels with VBA and data import in shared folder with collaborators) for several years now, without any macro blocking or security risk message. But recently, I shared the folder with other users with new office 365 installations. I am having the exact same problems as you, but only with the new computers. The old ones are working as always, even when they run the updated by subscription office 365. In the new computers, if I copy the file to a trusted local folder, it runs fine, but if I return or save the file in the onedrive shared folder the problem returns. It seems to me that the problem is that excel do not recognize onedrive folders as trusted ones on new installation. The most confusing thing is that the old computers run those files just fine, and they have not inherited the security policies with the office or onedrive update. I hope this mentioned here give us light to point into the right direction to a solution.