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

aalter's avatar
aalter
New member | Level 2
4 years ago

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...
Desktop
Microsoft Office
Share
Shared Files
Daphne's avatar
Daphne
Icon for Dropbox Staff rankDropbox Staff
4 years ago

Hi 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!

  • aalter's avatar
    aalter
    New member | Level 2
    4 years ago

    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's avatar
      Daphne
      Icon for Dropbox Staff rankDropbox Staff
      4 years ago

      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!

      • MRRalfacomputer's avatar
        MRRalfacomputer
        New member | Level 2
        4 years ago

        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

         

About Create, upload, and share

Find help to solve issues with creating, uploading, and sharing files and folders in Dropbox. Get support and advice from the Dropbox Community.

Need more support

If you need more help you can view your support options (expected response time for an email or ticket is 24 hours), or contact us on X or Facebook.

For more info on available support options for your Dropbox plan, see this article.

If you found the answer to your question in this Community thread, please 'like' the post to say thanks and to let us know it was useful!