Common Excel formulas errors explained

By | November 12, 2014

#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 | October 3, 2014

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: 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 | October 3, 2014

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 | October 3, 2014

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.

The automatically saved settings file ‘CurrentSettings.vssettings’ cannot be found error

By | September 30, 2014

I moved my documents from D drive back to C and this is what I got in both Visual Studio and Microsoft SQL Server Management Studio: The automatically saved settings file 'sql server management studioSettingsSQL Server Management StudioCurrentSettings-2013-06-06.vssettings' cannot be found. You can change this file on the 'Import and Export Settings' Tools Options page. The IDE will use your most recent settings for this session. To fix this: Step 1 Go to Tools/Options SQL Server Management Tools/Option or Visual Studio Tools/Option Step 2 Go to Environment/Import and Export Settings and change the path to existing one.… Read More »

How to export RSS feeds from Outlook 2013

By | September 20, 2014

This will show you how to export your RSS feeds from Outlook 2013 to any other program/service by OPML file. Step 1 Click FILE tab Step 2 Click Open & Export option Step 3 Click Import/Export button Step 4 Select Export RSS Feeds to an OPML file option. Click Next. Step 5 Select which feeds you want to… Read More »