I am trying to enable the Analysis Toolpack add-in for Excel Pro Plus 2019. This add-in has worked fine in every other version of Excel, but I'm receiving an error when attempting to enable it in 2019.
Steps to produce the error: Open Excel > File > Options > Add-Ins > Go > Check Analysis ToolPak > OK
Error: Cannot run the macro 'GetATPUICultureTag'. The macro may not be available in this workbook or all macros may be disabled.
The error then continues to present every time you open Excel unless you uncheck the add in. With the add in enabled, I also get this error when clicking the Data tab on the ribbon.
Error: Cannot run the macro 'FUNCRES.XLAM!GetGroupName'. The macro may not be available in this workbook or all macros may be disabled.
The Analysis button shows on the Data Tab, but it is missing its text caption, and nothing happens when you click it.
Clean install of windows and office, off the domain and off-network, to ensure there are not any restricted network policy settings. Same results.
Downloaded the newest office click to run deployment tool to create a new setup baseline XML configuration and installer. Used Office CDN for source, and most lax security to ensure that all macros and add-ins would be allowed. Same results.
Attempted to copy the Add-In files from an install of office 2016 into the working directory for office 2019. Same results.
Reproduced on Win10 1909, 2004, and 20H2...
Note that this is not related to an actual macro-enabled workbook; this happens in a blank workbook.
Attempting to use the Office 365 installer downloaded from Office.com, rather than the Pro Plus version we install by default.
Uninstall Office 2019 and install Office 365: Interestingly enough, the errors above do not happen. Instead, I receive a rather unhelpful Microsoft Visual Basic for Applications "400" error... Nice. And the add-in does not work.
Clean install of Win10 with no office install, Install Office 365: This Does work. Curious, that. So the Office 2019 install is leaving something behind that prevents Office 365 from utilizing the Analysis toolpack? I don't view this as a good solution due to:
Requiring a different version of Office than the rest of the 3000 computers I manage.
If we get requests for the analysis toolpack en mass it will mean redeploying the machine every time...
Attempting to use Office 2016, rather than the Pro Plus version we install by default.
Uninstall Office 2019 and install 2016: Same results. Apparently whatever 2019 breaks sticks around for 2016.
Clean install of Windows with a clean install of Office 2016: This works like normal. However it has the same drawbacks as using Office 365 above.
Is anyone else able to reproduce this? I don't understand how I can download a clean Win10 ISO from Microsoft volume licensing center, an Office install via Office CDN, and this happens from the clean install. Is this a bug? Or am I just not crossing my fingers?
Would love any pointers for things to try. Or, is there an alternative add-in/software?