excel16.admx – 173 policies
Microsoft Excel 2016
No policy found.
Microsoft Excel 2016 › Customizable Error Messages
Microsoft Excel 2016 › Data Recovery
- Do not show data extraction options when opening corrupt workbooksextractdatadisableui
Microsoft Excel 2016 › Disable Items in User Interface › Custom
Microsoft Excel 2016 › Disable Items in User Interface › Predefined
- Disable predefined commandsfilewebpagepreview
- Disable shortcut keysfind
Microsoft Excel 2016 › Excel Options › Advanced
- Alert before overwriting cellsfnodragwarning_76_1
- Allow formatting and labels to track data pointscharttrackingrefbased
- Alternate startup file locationaltstartup
- Ask to update automatic linksfupdateext_78_1
- Automatically Flash Fillflashfill
- Automatically insert a decimal pointautodec
- Commentsvmdnotedisp_38_2
- Cursor movementcursorvisual
- Cut and copy objects with cellsfobjwcellmove_71_1
- Default sheet directiondefaultsheetr2l
- Edit directly in cellfnoincell_66_1
- Enable AutoComplete for cell valuesfautocomplete_128_1
- Enable automatic percent entryfdisableautopercent_99_1
- Enable fill handle and cell drag-and-dropfdisabledman_36_1
- Extend data range formats and formulasextendlist
- Force support for Unicode surrogates in Excel 2021 and Excel 2024forcesupportforunicodesurrogates
- Function tooltipsfshowfuntips_101_1
- Ignore other applicationsfddeenabled_6_1
- Microsoft Excel menu or Help keymenukey
- Move selection after Enterfentermove_75_1
- Move selection after Enter directionmoveenterdir
- Number of folders in the Recent Folders listmax display
- Number of workbooks in the Recent Workbooks listmax display
- Show Alert if Excel is not the default for its associated file typesalertifnotdefault
- Show control characterscontrolcharacters
- Show Formula bar in Full Viewffmlafull_68_1
- Show Formula bar in Normal Viewffmlaf_1_1
- Show Insert Options buttonsenableinsertcellsooui_102_1
- Show namesfshowchartnames_96_1
- Show Paste Options button when content is pastedpasteoptions
- Show valuesfshowcharttipvalues_97_1
- Transition navigation keysfisi_33_1
- Zoom on roll with IntelliMousefrollzoom_98_1
Microsoft Excel 2016 › Excel Options › Advanced › Web Options... › General
- Load pictures from Web pages not created in Exceldonotloadpictures
Microsoft Excel 2016 › Excel Options › Customize Ribbon
- Display Developer tab in the Ribbondevelopertools
Microsoft Excel 2016 › Excel Options › Formulas
- R1C1 reference stylefrefa1_4_1
Microsoft Excel 2016 › Excel Options › General
- Default Fontfont
- Default Sheetsdefsheets
- Enable Live Previewlivepreview
- Show all windows in the Taskbarshowwindowsintaskbar
- Show Mini Toolbar on selectionallowselectionfloaties
- Show Quick Analysis options on selectionallowquickanalysis
Microsoft Excel 2016 › Excel Options › Proofing › Autocorrect Options
- Include new rows and columns in tableautoexpandlistrange
- Internet and network paths as hyperlinksautohyperlink
Microsoft Excel 2016 › Excel Options › Save
- AutoRecover delayautorecoverdelay
- AutoRecover save locationautorecoverpath
- AutoRecover timeautorecovertime
- Default file formatdefaultformat
- Default file locationdefaultpath
- Disable AutoRepublishdisableautorepublish
- Do not show AutoRepublish warning alertdisableautorepublishwarning
- Keep the last AutoSaved versions of files for the next sessionkeepunsavedchanges
- Prompt for workbook propertiesfpromptsuminfo_65_1
- Save AutoRecover infoautorecoverenabled
- Suppress file format compatibility dialog box for OpenDocument Spreadsheet formatdisablesaveaslosswarningopendocumentspreadsheet
Microsoft Excel 2016 › Excel Options › Security
- Block Insecure Protocols in Excel Worksheet Functionsblockinsecureprotocolworksheetfunctions
- Force file extension to match file typeextensionhardening
- Perform file validation on pivot cachespivotoptions
- Scan encrypted macros in Excel Open XML workbooksexcelbypassencryptedmacroscan
- Turn off file validationenableonload
- WEBSERVICE Function Notification Settingswebservicefunctionwarnings
Microsoft Excel 2016 › Excel Options › Security › Cryptography
- Configure CNG cipher chaining modecipherchaining
- Set CNG cipher algorithmcipheralgorithm
- Set CNG cipher key lengthcipherkeybits
- Set CNG password spin countpasswordspincount
- Set parameters for CNG contextcontext
- Specify CNG hash algorithmhashalgorithm
- Specify CNG random number generator algorithmrngalgorithm
- Specify CNG salt lengthsaltbytes
- Specify encryption compatibilitycompatmode
- Use new key on password changenewkeyonpwdchange
Microsoft Excel 2016 › Excel Options › Security › Trust Center
- Block Excel XLL Add-ins that come from an untrusted sourceblockxllfrominternet
- Block macros from running in Office files from the internetblockcontentexecutionfrominternet
- Disable all application add-insdisablealladdins
- Disable Trust Bar Notification for unsigned application add-ins and block themnotbpromptunsignedaddin
- Macro Notification Settingsvbawarnings
- Prevent Excel from running XLM macrosxl4macrooff
- Require that application add-ins are signed by Trusted Publisherrequireaddinsig
- Set maximum number of trust records to preservemaxpreservetrusteddocuments
- Set maximum number of trusted documentsmaxtrusteddocuments
- Store macro in Personal Macro Workbook by defaultfglobalsheet_37_1
- Trust access to Visual Basic Projectaccessvbom
- Turn off trusted documentsdisabletrusteddocuments
- Turn off Trusted Documents on the networkdisablenetworktrusteddocuments
Microsoft Excel 2016 › Excel Options › Security › Trust Center › External Content
- Always prevent untrusted Microsoft Query files from openingenableblockunsecurequeryfiles
- Don’t allow Dynamic Data Exchange (DDE) server launch in Exceldisableddeserverlaunch
- Don’t allow Dynamic Data Exchange (DDE) server lookup in Exceldisableddeserverlookup
Microsoft Excel 2016 › Excel Options › Security › Trust Center › File Block Settings
- dBase III / IV filesdbasefiles
- Dif and Sylk filesdifandsylkfiles
- Excel 2 macrosheets and add-in filesxl2macros
- Excel 2 worksheetsxl2worksheets
- Excel 2007 and later add-in filesxlamfiles
- Excel 2007 and later binary workbooksxlsbfiles
- Excel 2007 and later macro-enabled workbooks and templatesxlsmandxltmfiles
- Excel 2007 and later workbooks and templatesxlsxandxltxfiles
- Excel 3 macrosheets and add-in filesxl3macros
- Excel 3 worksheetsxl3worksheets
- Excel 4 macrosheets and add-in filesxl4macros
- Excel 4 workbooksxl4workbooks
- Excel 4 worksheetsxl4worksheets
- Excel 95 workbooksxl95workbooks
- Excel 95-97 workbooks and templatesxl9597workbooksandtemplates
- Excel 97-2003 add-in filesxl97addins
- Excel 97-2003 workbooks and templatesxl97workbooksandtemplates
- Excel add-in filesxllfiles
- File Block includes external link filesfileblockexternallinks
- Legacy converters for Excelconverters
- Microsoft Office data connection filesofficedataconnections
- Microsoft Office Open XML converters for Excelooxmlconverters
- Microsoft Office query filesofficequeries
- Offline cube filesofflinecubefiles
- OpenDocument Spreadsheet filesopendocumentspreadsheet
- Other data source filesofficedatasources
- Set default file block behavioropeninprotectedview
- Text filestextfiles
- Web pages and Excel 2003 XML spreadsheetshtmlandxmlssfiles
- XML filesxmlfiles
Microsoft Excel 2016 › Excel Options › Security › Trust Center › Protected View
- Always open untrusted database files in Protected Viewenabledatabasefileprotectedview
- Always open untrusted text-based files in Protected Viewenableforeigntextfileprotectedview
- Do not open files from the internet zone in Protected Viewdisableinternetfilesinpv
- Do not open files in unsafe locations in Protected Viewdisableunsafelocationsinpv
- Open files on local Intranet UNC in Protected Viewdisableintranetcheck
- Set document behavior if file validation failsopeninprotectedview
- Turn off Protected View for attachments opened from Outlookdisableattachmentsinpv
Microsoft Excel 2016 › Excel Options › Security › Trust Center › Trusted Locations
- Allow Trusted Locations on the networkallownetworklocations
- Disable all trusted locationsalllocationsdisabled
- Trusted Location #1path
- Trusted Location #10path
- Trusted Location #11path
- Trusted Location #12path
- Trusted Location #13path
- Trusted Location #14path
- Trusted Location #15path
- Trusted Location #16path
- Trusted Location #17path
- Trusted Location #18path
- Trusted Location #19path
- Trusted Location #2path
- Trusted Location #20path
- Trusted Location #3path
- Trusted Location #4path
- Trusted Location #5path
- Trusted Location #6path
- Trusted Location #7path
- Trusted Location #8path
- Trusted Location #9path
Microsoft Excel 2016 › File tab › Check Accessibility
- Check for accessibility issues while editingenableaccchecker
- Stop checking for alt text accessibility informationalttext
- Stop checking for blank table rows used as formattingblanktablerows
- Stop checking for merged cellsmergedcells
- Stop checking for table alt text accessibility informationtablealttext
- Stop checking for table header accessibility informationtableheaders
- Stop checking to ensure hyperlink text is meaningfulmeaningfulhyperlinks
- Stop checking to ensure non-default sheet namessheetnames
- Stop checking to ensure workbooks allow programmatic accessprogrammaticaccess
Microsoft Excel 2016 › Miscellaneous
- Block all unmanaged add-insrestricttolist
- Disable Office Scripts in Excel for Windows Desktopdisableofficescripts
- Disable the Office Start screen for Exceldisableboottoofficestart
- Do not cache network files locallynetworkresiliency
- Enable four-digit year displayenablefourdigityeardisplay
- Graph gallery pathgallerypath
- List of managed add-ins
- OLAP PivotTable User Defined Function (UDF) security settingolapudfsecurity
- Personal templates path for Excelpersonaltemplates
- Show custom templates tab by default in Excel on the Office Start screen and in File | Newofficestartdefaulttab
Microsoft Excel 2016 › Miscellaneous › Server Settings
- Turn off file synchronization via SOAP over HTTPfsshttpoffexcel
Microsoft Excel 2016 › Power BI
- Disable displaying organization name in the buttons to create PivotTables from Power BI datasetsdisablefrompowerbidatasetorganizationname