ASzewczyk wrote:I have the same issues: no problems with Excel 2010. Now, Excel 2016 356 gives the same result (picture attached).
Our IT support checked carefully security options and they cannot find solution…
Indeed, it is very handy tool. Help would be appreciated a lot.
Similar to the questions that I asked the previous poster, but more specifically:
(a) What's the
exact path that you have the add-in on?
(b) is it a local path, or a network path? (Or, for that matter, a cloud path like OneDrive)?
(c) Do you have
that exact path set as a Trusted Location?
Here's the reason that I'm asking that; it's not something that I found with TM1Tools but with another macro-enabled workbook.
I had my OneDrive folder (in my case, F:\Users\UsereName\OneDrive) set as a Trusted Location in Office 2010, with "Subfolders allowed". Because as incredible as it is for those walking genetic defect notices in Redmond to believe, I do not actually put potentially virally infected files into my own folder. And I don't give anyone else access to that folder. So yeah, if there is a folder under that path I kinda trust myself
not to have put a freaking virus into it.
In Office 2010 this worked without a hitch.
Then along came the putrid, stinking piece of floating excrement that passes itself off as a spreadsheet program called Excel 2016.
Excel 2016 (along with the rest of the Office 2016 family) was formulated on the assumption that everyone works on the Microsoft campus at Redmond, or works remotely at the local Starbucks just down the road from there which has a 10 terabyte per nanosecond WiFi connection. (Bear with me, you'll see where I'm going with this.) For example, the Help files are now only available on line and when people asked for offline availibility to be returned, the Office development team's response was to
stick their middle finger up in the users' collective face. If you are (as I often am) commuting in an area which is a wireless dead zone, the only "Help" that you will get from Office Help is advice to check your Internet connection, and then try and guess the solution.
Another example; the "Recent Folders" list has been removed from the File -> Open command. You only get recent files. The reasoning behind that is that everyone should be saving to OneDrive anyway, notwithstanding that even those of us who
do use OneDrive do not save to the root folder and therefore the absence of the recent folders list still makes it take far longer than it should to find the files that we want, especially for ones which were from a few weeks prior. (The list was recently returned to the File => Save As command (for Office 365 users only, not 2016 standalone packages) after a large user outcry. Microsoft patted itself on the back for being sooooo responsive to user needs, with not a hint of apology or contrition for having screwed us in the first place.)
So, what's the significance of all this?
The old model of OneDrive was to save to the OneDrive folder and the OneDrive application would then sync the files to the sever.
The new Office 2016 model is to write the frapping files directly to the OneDrive server; see the aforementioned "everybody lives in a fantasy world of 24/7 100% reliable internet connections". That means that the OneDrive folder is kinda-sorta more or less like a network location, even if it's actually just a folder on your hard disk.
I discovered the upshot of this when I opened an .xslm in Excel 2016 from a subfolder of OneDrive and none of the VBA code worked. I checked that OneDrive was still a trusted location. Yup. I checked that subfolders were still trusted. Yup. So I spewed a stream of invective in both English and Italian at my monitor in the hope that the vibes would somehow make their way through the network to the Microsoft campus and cause the roof to collapse in the Office development team's building, entombing all of them inside and instantaneously improving the overall quality potential of global software by maybe 20%.
Alas it didn't happen.
So I sat and pondered for a few minutes about the New! Paradigm! Shift!, and noticed that "Allow trusted locations on my network" was not checked. It didn't need to be for OneDrive to work
the way I told it to in Office 2010. But sure enough, I found that if you don't have that box checked, Microsoft, who knows far better than you do what is good for you, will still treat OneDrive as an untrusted location
regardless of your explicit instructions to the contrary.
Now, you may not be storing it on OneDrive at all. But with this setting you can see how it may be that a location
appears to be trusted, but is actually not.
As I said to the previous poster, there is nothing intrinsically wrong with the add-in in Excel 2016; I use it every time I can bring myself to face that worthless piece of junk. (I still use 2010 for most things.) And it
does work. That's why I'm betting on a trust issue being at the root of this, even if it's something cryptic like the example that I described above.