Power User Archives - SharePoint Sharks Blog

The workbook that you selected cannot be opened

by Administrator Last updated April 3, 2018 Comments

This error can occur when Excel application pool account is stuck or when the document library containing the Excel file is not in a trusted location. here is the solution…

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 November 13, 2017 Comments

These are the option 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…