You might see that the Dropbox Community team have been busy working on some major updates to the Community itself! So, here is some info on what’s changed, what’s staying the same and what you can expect from the Dropbox Community overall.
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 Staff
Dropbox StaffHi 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
- WalterHey MRRalfacomputer, sorry to jump in here, but I think you'll find your answer in this discussion.
At your convenience, please take a look and let us know if you have anything else to ask.
