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...
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
Dropbox Staff
Dropbox StaffThanks 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.I need to run the macros I chose dropbox and shared .xlsm file with one user but we are not able to take action or run the macros using dropbox. I chose to open file using excel for web but same ..
Actulally after filing information upon clicking button or image the macro runs also upon right click of mouse the macro runs but it's not happening online using dropbox share.
I need this to work essentially as this is team work for us.
