Forum Discussion
FDOandrade
Oct 05, 2023Copper Contributor
Issues Enabling Macros in a Shared Excel Workbook on OneDrive
Hello everyone, I have designed an Excel workbook on my computer that contains VBA macros. This workbook is stored in a shared folder on OneDrive and is accessed daily by multiple collaborators from...
alextinfr
Nov 24, 2023Copper Contributor
FDOandrade I figured out a work around to the problem. The old one drive app has an option to disable office apps collaboration. To stop excel from using onedrive paths instead of local paths you had to turn it off. In the new onedrive app, that option disappeared. Try this. Go to your onedrive app icon, and (left click) go to pause synchronization and exit onedrive. Then go to your excel file and open it. If the problem is gone, go to onedrive app settings and turn off the "disable Office Apps collaboration" option. If that option does not appear in your onedrive app, then uninstall onedrive, install an older version, disable the office collaboration option, and update onedrive. The problem should disappear... I hope this helps