Power User Archives - SharePoint Sharks Blog

SharePoint Excel Services and Excel Web Access : The workbook that you selected cannot be opened

by Administrator Last updated August 28, 2018 Comments

Excel Services Web Access web-part This error can happen when a user is using Excel Services to add an Excel Web Access web-part on a SharePoint page. The root cause may…

Open document library in file explorer view doesn’t work

by Administrator Last updated March 28, 2018 Comments

In my case I couldn’t open explorer view on a SharePoint 2007 library. the resolution was to switch my IE 11 compatibility view to 10, this resolved the issue. Add…

Remove the comma in SharePoint Numeric field

by Administrator Last updated August 14, 2019 Comments

These are the options available : Turn the field into a text field, and on the field’s validation rule add the following formula: =ISNUMBER([ColumnName]+0) The down side is that…