Show Quick Analysis options on selection

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.

Supported on: At least Windows 7

Registry Hive	HKEY_CURRENT_USER
Registry Path	software\policies\microsoft\office\16.0\common\toolbars\excel
Value Name	allowquickanalysis
Value Type	REG_DWORD
Enabled Value	1
Disabled Value	0

excel16.admx

Administrative Templates (Computers)

Microsoft Office 2016 (Machine)
Microsoft PowerPoint 2016 (Machine)
- Converters
  - Turn on an external converter as the default for a file extension
Skype for Business 2016
- Microsoft Lync Feature Policies

Administrative Templates (Users)

Microsoft Access 2016
- Application Settings
- Customizable Error Messages
  - List of error messages to customize
- Disable Items in User Interface
  - Custom
    - Disable commands
    - Disable shortcut keys
  - Predefined
    - Disable commands
    - Disable shortcut keys
- Miscellaneous
- Tools | Security
  - Workgroup Administrator...
    - Path to shared Workgroup information file for secured MDB files
  - Modal Trust Decision Only
Microsoft Excel 2016
Microsoft Office 2016
Microsoft OneNote 2016
- OneNote Options
Microsoft Outlook 2016
Microsoft PowerPoint 2016
Microsoft Project 2016
- Miscellaneous
- Project Options
  - Calculation
    - Calculation options for 'Project1'
    - Calculation options for Microsoft Project
      - Automatic Calculation
      - Calculate all open projects
  - Calendar
  - Customize Ribbon
    - Display Developer tab in the Ribbon
  - Edit
    - Edit options for Microsoft Project
    - Hyperlink appearance in 'Project1'
    - View options for time units in 'Project1'
      - Add space before label
      - Days
      - Hours
      - Minutes
      - Months
      - Weeks
      - Years
  - General
    - General options for 'Project1'
    - General options for Microsoft Project
    - Undo Levels
  - Interface
    - Project Guide settings for 'Project1'
      - Project Guide Content
      - Project Guide Functionality and Layout page
    - Project Guide settings
      - Display Project Guide
    - Show indicators and Option butons for
    - Disable Internal ID Matching
  - Save
    - Auto Save Options
    - File locations
      - Projects
      - User Templates
    - Tools | Local Project Cache
      - Local Project Cache Location
      - Local Project Cache Size Limit in MB
    - Save Microsoft Project files as
  - Schedule
    - Schedule options for Microsoft Project
      - Show assignment units as
      - Show scheduling messages
    - Scheduling options for 'Project1'
  - Security
  - View
    - Calendar Type
      - Calendar Type
    - Show
    - Date Format
    - Default Project Currency
    - Default View
    - Project Summary Task
Microsoft Publisher 2016
Microsoft Teams
- Prevent Microsoft Teams from starting automatically after installation
- Restrict sign in to Teams to accounts in specific tenants
Microsoft Visio 2016
- Customizable Error Messages
  - List of error messages to customize
- Disable Items in User Interface
  - Custom
    - Disable commands
    - Disable shortcut keys
  - Predefined
    - Disable commands
- Miscellaneous
- Visio Options
  - Advanced
  - Customize Ribbon
    - Display Developer tab in the Ribbon
  - General
    - User Interface Options
  - Proofing
    - AutoCorrect Options
  - Save
    - Offline Editing
      - Save checked-out files to
    - Save Documents
      - Prompt for document properties on first save
      - Save Visio files as
    - Turn off CAD/DWG functionality
  - Security
    - Macro Security
      - Enable Microsoft Visual Basic for Applications project creation
      - Load Microsoft Visual Basic for Applications projects from text
    - Trust Center
Microsoft Word 2016
Skype for Business 2016
- Microsoft Lync Feature Policies