Common issues found in Visual Studio

1. Not connecting to Nuget Package Manager

Go to C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE

Open devenv.exe.config. Comment these lines.

 One more issue is related to latest version of nuget

From (MSDN Question)

There seems to be an issue with the later version of nuget source at url https://www.nuget.org/api/v2/

To fix the issue...go to Tools -> NuGet Package Manager -> Package Manager Settings, under Package Sources create a new package source
Name: NugetSource
Source: http://packages.nuget.org/v1/FeedService.svc/

Move the newly created source to the top of the list under Available package sources. Click OK and restart Visual Studio.

2. Bad Image Format Exception while accessing Excel.

One of the problem is because Ole DB runs only in 32 bit machine. Solution for this is


Go to Solution Items -> Test Settings -> Host -> Force Test to run in 32 bit process

3. Test Context is accessing 2 excel sheets and getting access violation error. 

This might be because test context is not closed properly. Close Test Context of first sheet before accessing another sheet.