Common Excel formulas errors explained

By | June 10, 2016

#VALUE! The formula has the wrong type of argument Excel found type of data which was not expected there. The most common cause is when you use a function or create a formula with a cell that has text instead of numbers. Other might be that single value is expected but a whole range is returned. #NAME? Name… Read More »

[Solved] Force web, whole list or library to be re-crawled by search in SharePoint 2013 using API

By | May 12, 2016

There is a new option in SharePoint 2013 that allows you to re-index list or document library. You can find more about this on those blogs: http://blogs.msdn.com/b/armenk/archive/2013/02/12/how-to-force-whole-list-or-library-to-be-re-crawled-by-search.aspx http://www.learningsharepoint.com/2012/12/17/the-new-reindex-list-and-reindex-document-library-option-in-sharepoint-2013 Important:It does not work in SharePoint 2010! It is also possible to do it for whole web. Thanks to this all items in all lists will be re-crawled. I would… Read More »

System.IO.FileNotFoundException was unhandled while opening SPSite

By | May 12, 2016

If you get below exception in custom application, when you try to open Site to which you have rights, check “Project Properties/Build/Platform target”.  Change it from: “x86” to “Any CPU” or “x64”.

Invalid URI: The Uri string is too long with XmlDocument

By | May 12, 2016

When you get:

on XmlDocument while loading xml from string make sure you use: XmlDocument.LoadXml(string) Loads the XML document from the specified string. and not XmlDocument.Load(string) Loads the XML document from the specified URL.