Need to see if your shared folder is taking up space on your dropbox 👨💻? Find out how to check here.
Forum Discussion
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...
Hannah
Dropbox Community Moderator
Dropbox Community ModeratorThanks for the additional info and the screenshot, lanos.
Can you try the following steps (if you haven't already) and let me know if they help?
- Ensure your Dropbox file is fully synced and stored locally on your computer.
- Open File Explorer.
- Locate your Excel file, right-click it, and select Properties.
- If you see an Unblock button or checkbox, click it and then Apply.
- Open Excel.
- Click File.
- Click Options.
- Click Trust Center Settings.
- In the Trust Center window, select Trusted Locations
- Click Add new location.
- Click Browse to locate your local Dropbox folder and select it. Ensure the Subfolders of this location are also trusted box is checked.
- Click Ok to add it.
- In the Trust Center window, go to Macro Settings.
- Select an option that enables macros such as Enable VBA macros.
- Click Ok.
- Restart Excel and open your file from your trusted Dropbox folder.
Hannah thanks for these steps. With Dropbox for Teams, the option to Unblock in Properties is no longer available. I verified all the other options had been selected as you detailed, but macros still do not work and I get the same error message.
- Jay
Hi lanos, thanks for the info regarding this matter. In order to look into this behavior in more detail, I'd recommend contacting the support team directly for them to investigate further.
