Create a Blocked File Type

Solution: Use the New-SPExcelBlockedFileType cmdlet.

The New-SPExcelBlockedFileType cmdlet can be used to block a specific type of Excel workbook from Excel Services. Provide the file type and the Excel Services Application instance, as shown in Listing 21.13.

Listing 21.13. Creating a New Blocked File Type

New-SPExcelBlockedFileType
-ExcelServiceApplication "Excel Services Application" -FileType XLSB

The -FileType can be one of the following:

• XLSX

• XLSM

• XLSB

Essentially, you are blocking Excel workbooks, macro-enabled workbooks, or binary-enabled workbooks (or some combination thereof).