Macros have been blocked for my Excel files.

DeKristof wrote:

Here same issue, microsoft blocks the execution of the macro's. Will Dropbox provide a solution for this ...

This isn't a Dropbox problem. Microsoft Office blocks all macros unless the file location is a trusted source. You can add the path of your Dropbox folder as a Trusted Location in the Trust Center Settings within the Office application that you're using. It's under File/Options/Trust Center.

Hey DeKristof, thanks for the nudge here.

Would you mind sending us some screenshots of what you see for the macros failing? Especially if you're getting some kind of error, it would be really helpful for us to have a visual.

Also, to confirm what Rich mentioned in his reply above, the location of the file shouldn't change, so if this is something you see on your end, please include a screenshot of that too.

And lastly, you are in fact using the Dropbox desktop app, right? If so, are the files in question set to "available offline" or "online-only"?

Here same issue, microsoft blocks the execution of the macro's.  Will Dropbox provide a solution for this or do we need to use Onedrive instead?

BentHolm wrote:

I have tried to work with the files as avaiable offline, but then the path to the files is different.

A file doesn't change location when switching between online and offline, so its path would be the same. When you take your screenshots, please include examples of how you see the path changing on your files.

Hi 
I have tried to work with the files as avaiable offline, but then the path to the files is different.
Which seems a little strange.
The Macro problem is solved when i work with the files offline.
But in our macros we refer to the path, and it can not find the path when it is offline.
I will send you some screendumps when i have a failing PC in my hands.

Hey BentHolm!

What Rich mentioned is true. It sounds like this is an Excel issue, or setting rather than a Dropbox one. With that being said, I can't provide you with the exact steps on how to resolve it.

However, on our side the best thing that you can do is make sure to sync these files as available offline before starting to work with them.

It might have to do with the fact that online-only files aren't fully synced locally to the device. All you see inside your Dropbox folder is the file's placeholder, and not the actual data of the entire file. 

If you need something else, please let me know and I will be more than happy to help every step of the way. 

On my PC i do not have the path to the dropbox files in the thrusted setting.
But it is on thoose where the problem is.

I think it has something to do with an windows update, but my PC with Windows 10 and full up to date with all updates, does not have the problem.
My Dropboks is version 232.4.5988.
Have not yet checked thoose which have the problem, what they are running 

It is with online files only

Hey BentHolm! 

Do you notice this behavior both with available offline, and online only files? What icons do these files have next to them when you locate them inside your Dropbox folder?