This course will help you learn the basics or refresh your knowledge and then provide a deeper understanding of advanced features of SharePoint 2013 from beginners to advanced users.
In this blog, we will learn how to remove the blocked file type in a location using PowerShell cmdlets.
Excel Service Application
SharePoint 2013 is a collaboration environment that organizations of all sizes can use to increase the efficiency of business processes.
Excel Service Application
- Excel Service is a business intelligence tool that allows you to share the data-connected workbooks across an organization.
- Excel Service in SharePoint Server 2013 is a shared service that you can use to publish Excel 2013 workbooks on SharePoint Server.
Why we are using these commands.
Excel Service Application loads only workbooks that are stored in a trusted file location.
Steps
- Open your SharePoint Management Shell.
- Copy the below code.
- Run this one.
Remove-SPExcelBlockedFileType [-Identity] <SPExcelBlockedFileTypePipeBind> -ExcelServiceApplication <SPExcelServiceApplicationPipeBind> [-AssignmentCollection <SPAssignmentCollection>] [-Confirm [<SwitchParameter>]] [-WhatIf [<SwitchParameter>]]
Example
Get-SPExcelServiceApplication -Identity "ExcelServiceApplication" | Remove-SPExcelBlockedExcelFileType -FileType XLSX
Conclusion
Was my blog helpful? If yes, please let me know and if not, please explain what was confusing or missing. I’ll use your feedback to double-check the facts, add info and update this blog.