Load Test ribbon does not appear in Excel 2010

Question

I have VS2010 Ultimate and Excel 2010 (both 32-bit) on Win 7 Pro (64-bit).  The "Load Test" ribbon tab has gone missing.  I have tried removing/adding the COM Add-in through Excel: C:\Program Files (x68)\Microsoft Visual Studio 10.0\Visual Studio Tool for Office\x86\VSTOExcelAdapter.dll

How does one re-enable the load test ribbon without re-installing/repairing VS2010?

Thank you.

Answer 1

May be try with SP1, take a look at this thread http://social.msdn.microsoft.com/Forums/hr/vstswebtest/thread/f946769e-cc1d-4972-810a-04eb427047c0

Thanks,

Anuj

---

http://www.anujchaudhary.com

Answer 2

Hi Anuj,

Thank you for your friendly assistance.

Hi Rogge,

Thank you for posting in the MSDN forum.

Would you mind letting us know the result of the suggestion? Whether it works after you install the SP1?

If there's any concern, please feel free to let us know.

Sincerely,

---

Jack Zhai [MSFT]
MSDN Community Support | Feedback to us

Answer 3

Excel 2010 (14.0.6112.5000) SP1 MSO (14.0.6112.5000)
VS2010 10.0.40219.1 SP1Rel

I tried double clicking Microsoft.VisualStudio.QualityTools.LoadTestExcelAddIn.vsto, but many references were not in the correct folder... I tried copying them from else where to the appropriate directory, then i got a hash/manifest error for Microsoft.Office.Tools.Excel.dll.

Before I ask IT to repair VS2010, any other suggestions?

Answer 4

Hi Rogge,

Glad to receive your reply.

I’m afraid that we will need to reinstall the VS, since it seems that it is the installing issue.

Maybe you could try to check it with the following steps.

You could locate to the IDE folder then run these commands, or you can set path to the system environment.

C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE

Devenv.exe /SafeMode: Launches the IDE in safe mode loading minimal windows.

Devenv.exe /ResetSettings: Restores the IDE's default settings, optionally resets to the specified VSSettings file.

Devenv.exe /ResetAddin: Removes commands and command UI associated with the specified Add-in.

Devenv.exe /ResetSkipPkgs: Clears all SkipLoading tags added to VSPackages.

Then check it again, if still no help, I suggest you could reinstall or repair your VS.

Best Regards,

---

Jack Zhai [MSFT]
MSDN Community Support | Feedback to us

Answer 5

Thanks Jack.

i'll talk to my IT dept... and be wary of others code as well (one of my co-workers has a macro that some how disable the drag-drop moving of a selected cell range and i couldn't restore that function without repairing office.).

-r