Need to see if your shared folder is taking up space on your dropbox 👨💻? Find out how to check here.
Forum Discussion
Excel file macros do not work in shared dropbox folder
I have an excel spreadsheet on my desktop computer that uses macros in order to automatically sort my tenants. When i upload this spreadsheet into a shared file folder with my partners, the macros no...
Daphne
Dropbox Community Moderator
Dropbox Community ModeratorHi aalter, thanks for reaching out to us here!
Do you have the file set to automatically run the macro when opening it?
Or are you able to run the macro once you open the file manually?
If you're getting any errors, please send along a screenshot of this.
Looking forward to hearing from you!
Nothing is working. I would need a specialist to help me.
I do not know where to input the code to automatically run macros in the workbook.
Manually run macros gives me this error. See attached photo
- Daphne
Thanks for your update here aalter.
In this case, I wouldn't be able to help much further with this, so I would suggest reaching out to Microsoft Support for some assistance with this.
They will have a much better insight into this since it's within the Excel app that you need to take these actions.
I hope this helps to some extent, just let me know if you have any questions!
Hello everyone,
I have exactly the same issue here.
I have a Dropbox business sharing folders and files with another Dropbox business.
Both users open the excel files on a desktop (mine is an OSx, hers is a Windows PC).The thing is: I created a file on excel with macros that works perfectly on both computers, but in hers, it just works if the file is saved and opened from OUTSIDE the dropbox shared folder.
When the excel file with macros opens on her computer from the dropbox shared folder, it does not even ask to able or disable macros. It acts like there are no macros at all.
Can someone please help me?
Thank you
