Load and web performance testing-Visual Studio 2012

Question

I am using Visual studio 2012.

I did load and web performance testing for my web application.

After my load testing i clicked Create Excel report it shows message like this

Could any one help me to solve this problem.

Answer 1

Hi Geetha,

Please launch Excel, go to "Excel Options" from application icon in ribbon, then go through below steps to enable the Load Test Add-in:

 

Answer 2

i did this already,still I am having trouble in create excel report in visual studio.

Answer 3

Hi,

What version of Microsoft Excel are you using?

In order to generate Microsoft Excel load test report from VS2012, you need both Visual Studio 2012 Ultimate and Microsoft Excel 2010 or later.

And Visual Studio 2012 Ultimate is not compatible with Microsoft Office 2007. You must upgrade to Microsoft Office 2010 or later. After upgrading to Microsoft Office 2010 or later, the Load Test Excel plug-in might not load properly. To correct this, in Microsoft Excel 2010 or later, follow these steps:

1. In the Office ribbon, choose File.
2. Choose Options and then choose Add-Ins.
3. In the drop-down list under Manage, choose COM Add-Ins,      and then select Go.

  4.Select the checkbox for Load Test Report Addin.

I am not sure how you enable the Load Test Report Addin, please do it step by step following the four steps above, then restart your PC, run VS as admin then generate load test report to check the result.

If the same issue still occur, another way to create load test report is to do it from Microsoft Excel Load Test menu->Load Test Report, for detailed steps, reference this blog: VSTS 2010 Feature: Load Test Excel Report Integration

Best regards,

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.