Show Quick Analysis options on selection
- Policy ID
- L_AllowQuickAnalysis
- Scope
- User Configuration
- Supported on
- At least Windows Server 2008 R2 or Windows 7
- Source
- Microsoft 365 Apps / Office Administrative Templates (version 5568.1000)
- Category
- Microsoft Excel 2016 › Excel Options › General
Description
This policy setting controls the "Show Quick Analysis options on selection" option found under File tab | Options | General | User Interface Options.
If you enable or do not configure this policy setting, Excel will show Quick Analysis options when data is selected. This is the default behavior.
If you disable this policy setting, Excel will not show these options on selection.
Registry
UserHKEY_CURRENT_USER
- allowquickanalysisREG_DWORD