Macros have been blocked for my Excel files.

Hi BentHolm, let's jump right into this! 

Do you use Excel online to preview your files? If so, then it might be worth pointing out that Excel online doesn't support Macros. 

If you're using the desktop app when this happens, feel free to have a closer look at this relevant thread too. 

Let me know more, and we'll take it from there!

Thanks

I have read that thread and  solution there did not work.

How ever if I choose to keep file Localy, (The option in Dropbox), I can enable macros, but then the macro failed as it can not find the files, as it refer to the path in the macros.

And do not think that is the best solution either.

BentHolm wrote:

And there is no option to activate Macros, as there used to be.

This is an Excel issue, unrelated to Dropbox. You likely need to go into the Trust Center Settings within Excel and add the path as a Trusted Location.

It work if i copy the file to local computer, so it is something about the tag that is put on when the file looks like it comes from the internet.
It also works on One drive.
If i move my files to new location, then the macros can be enabled but fails, as they can not find the path to the files.
So they must be on "The online version", in Dropbox

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? 

It is with online files only

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 

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.

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. 

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.