Built in Analysis Pack Getting "Cannot run the macro 'FUNCRES.XLAM!GetGroupName'."

Question

_{Wednesday, October 24, 2018 2:58 PM}

We have Office 2016 (msi version) on 1709 and when users try to use the Analysis Pack they either get one of two errors.

The first they would get just by clicking the "Data" tab after enabling the Analysis Pack Add-in.

1.) Cannot run the macro 'FUNCRES.XLAM!GetGroupName'. The macro may not be available in this workbook or all macros may be disabled.

If I set Group Policy for "User Configuration\Policies\Administrative Templates\Microsoft Office 2016\Global Options\Customize\ Disable UI Extending From Documents and Templates" to "Enabled" and then check the box for Excel to "Disallow" then this error goes away but the Data Analysis icon disappears from the ribbon and the functionality is reduced. In that case, if I go to remove and then re-add the Analysis Pack add-in then I get this:

2.) "The custom UI associated with this document has been disabled by policy" 

In Group Policy macros are disabled without notification (same setting we have in Win 7 where it's working just fine). Since this is a built-in, it should automatically be in the default Trusted Locations so it should skip the security check and macro settings should not matter.

The "Trust access to the VBA project object model" box is checked. 

I can't think of what would be causing this. Anything in TL should skip all security checks per MSFT documentation, so why is the macro getting blocked?

Thanks in advance.

WB

All replies (3)

_{Tuesday, October 30, 2018 1:56 PM ✅Answered}

What I found was that we had a GPO setting (User Configuration\Policies\Administrative Templates\Microsoft Office 2016\Security Settings\Automation Security) that was set to “Disable All Macros.” For some reason, even though Microsoft documentation states that Office will skip all security checks when an add-in is in a Trusted Location, it doesn’t skip this security check. If I change the policy to “Use Application Macro Security Level” then the add-ins and templates work, even though I have the setting for Excel and Word (User Configuration\Policies\Administrative Templates\Microsoft Excel 2016\Excel Options\Security\Trust Center\VBA Macro Notification Settings) individually set to “Disable All Without Notification”.

Not sure why this is the case, but at least it's resolved.

WB

_{Thursday, October 25, 2018 9:57 AM}

Hi,

Did you use 32bit version of Excel or 64bit version of Excel? Sometimes the error message may related to the incorrect version between add-in and Excel. You can try to reinstall the different bit version of Excel and see the result.

_{Thursday, October 25, 2018 6:47 PM}

It's a built-in add-in that's part of Excel, so unless Microsoft packaged the 32-bit version of their own add-in with a 64-bit install for Office, there shouldn't be any issues.