Hi
We got problem activating Macros in Excel when opening files from dropbox.Excel has a messages in the top saying that Macros has being blocked.And there is no option to activate Macros, as there used to be.
Any ideasBrgds Bent
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.
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.
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.
BentHolm wrote: I have tried to work with the files as avaiable offline, but then the path to the files is different.
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.
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?
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"?
DeKristof wrote: Here same issue, microsoft blocks the execution of the macro's. Will Dropbox provide a solution for this ...
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.
