Need to see if your shared folder is taking up space on your dropbox 👨‍💻? Find out how to check here.

Forum Discussion

fred10865's avatar
fred10865
Explorer | Level 3
4 months ago

Microsoft Excel file with macros doesn't work when on the drive

Hi I cannot run macros on my excel file thats in dropbox. On the web/desktop version both dont work. I made sure to enable macros (They work if I put the file on my desktop). I saw a solution to ad...
Microsoft Office
fred10865's avatar
fred10865
Explorer | Level 3
4 months ago

Yes my excel file is in the dropbox folder on my computer, It dosent work from there either!

Thanks,

Nancy's avatar
Nancy
Icon for Dropbox Community Moderator rankDropbox Community Moderator
4 months ago

Hey fred10865! Hope you don’t mind the nudge. 

Do you still need assistance with this? If you do, please reply to my previous questions. Otherwise, in case this has been resolved in the meantime, feel free to let us know what worked for you.

    • Nancy's avatar
      Nancy
      Icon for Dropbox Community Moderator rankDropbox Community Moderator
      4 months ago

      Glad to hear that, fred10865! Unfortunately, due to our Community guidelines, we had to remove the external link you shared. 

      However, please don’t hesitate to post any screenshots you may have with the solution you found. We’d love to know how you fixed this issue.

    • jpawlicki88's avatar
      jpawlicki88
      Explorer | Level 3
      3 months ago

      hi! can you share the steps you took without the link? im running into the same issue

      • fred10865's avatar
        fred10865
        Explorer | Level 3
        3 months ago

        In Regedit (as admin), navigate to: HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Security.

        Find or create the DWORD VBAWarnings:

        Set value to 1 (Enable all macros without warnings—global for all files; use cautiously as it's less secure).

        Alternative: Set to 2 (Disable with notification—prompts on open, but no per-file hassle; click "Enable Content" for trusted files)

About Integrations

Find solutions to issues with third-party integrations from the Dropbox Community. Share advice and help members with their integration questions.

The Dropbox Community team is active from Monday to Friday. We try to respond to you as soon as we can, usually within 2 hours.

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, Facebook or Instagram.

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!