Forum Discussion

JF9928's avatar
JF9928
Copper Contributor
Dec 05, 2023

Office security baseline breaks excel feature: "analysis toolpak"

Hi team,

 

I have found that the Office security baseline (Intune v2306) breaks an excel feature: analysis toolpak add-in (the data analysis menu item does not load).

 

There was a known issue note on the v2206 office baseline that stated the setting "Prevent Excel from running XLM macros" broke analysis toolpak and referred to a workaround:
https://support.microsoft.com/office/06cd719c-1e9b-4624-815b-c377ad5ca236

 

But, I have tested removing/disabling the "Prevent Excel from running XLM macros" from the baseline and the issue persists.  I also tested deploying/enabling only the "Prevent Excel from running XLM macros" and it doesn't cause the feature to stop working.  I've come to the conclusion that "Prevent Excel from running XLM macros" is no longer a relevant setting (and the workaround is no longer accurate).

 

I've tested a dozen settings from excel trust center without success in finding the offending setting.  The "analysis toolpak" doesn't show in the trust center logging.

 

1.  It looks like this needs to be a known issue for the office baseline again,

2.  Any recommendations on how to troubleshoot the issue (short of working through each setting in the baseline)?

1 Reply

Sort By
  • JF9928's avatar
    JF9928
    Copper Contributor
    Dec 05, 2023

    Found it:

     

    The baseline setting below prevents the data tab -> data analysis/solver menu items from appearing.

     

    Microsoft Office 2016 -> Security Settings -> Disable UI extending from documents and templates -> "Disallow in Excel = True"


    Changing "Disallow in Excel = False" allows the menu item to appear normally.

     

    This should be listed as a known issue on the office security baseline as long as this setting is included.

Resources