Agile Central: Excel - Why there is no CA Agile Central tab after installing the Excel Add-in ?

Document ID : KB000094858
Last Modified Date : 16/05/2018
Show Technical Document Details
Issue:
Why is there no "CA Agile Central" tab in Excel after installing the Add-in ?

CA Agile Central provides an Add-in to Microsoft's Excel. This Add-in will add a tab named: "CA Agile Central" to the excel tabs. This Add-in will help you organize your data. To learn more on the Excel add-in, see:

https://help.rallydev.com/rally-add-excel-installation-user-guide
https://help.rallydev.com/import-export-excel-addin

This article explains why this tab may not appear in Excel and how to make it appear again. The screen below is showing the tab that needs to be added to Excel:

User-added image
 
Cause:
Cause 1: The Add-in is not fully installed. Check Cause 1 in the Resolution section below to check the registry for the Add-in. 
Cause 2: The Windows machine is missing .NET Framework version 4.5 or higher, which is required for Add-in for Excel versions 2.44 and higher. 
Resolution:
Perform the following step in case you don't see a CA Agile Central tab in Excel:

Cause 1


Step 1: Check if that Add-in is installed.
a. Open up the Windows registry. From the start menu, enter "Regedit" into search field. The windows registry will open.

User-added image

In the Windows registry, locate the following path:
[HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\Rally.ExcelAddIn]

You shall see these keys and values in that path:

[HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\Rally.ExcelAddIn]
"LoadBehavior"=dword:00000003
"Manifest"="C:\\Program Files (x86)\\CA Technologies\\CA Agile Central Add-in for Excel\\RallyExcel.vsto|vstolocal"
"FriendlyName"="CA Agile Central Add-in for Excel"
"Description"="CA Agile Central Add-in for Excel"

If any of that is missing of incorrect, then you need to reinstall the Excel Add-in. Choose: "Repair" when running the installer again.

If the Windows registry looks okay, then proceed to Step 2.

Step 2: Enable and Activate the CA Agile Central COM Add-in in Excel.
Open up Excel. Right click in the empty space on the right hand side and select: "Customize Quick Access Toolbar..."

User-added image
An Excel Options window will pop up. In that Window, click the Add-Ins category on the left pane. You shall see your Excel's add-ins in the right pane. There are 4 categories for the Add-Ins: Active, InActive, Document Related, Disabled.

In order to get the CA Agile Central tab you need to make certain that the "CA Agile Central Add-in for Excel" is in the Active category.

a. Disabled:
If you see this Add-in in the Disabled group then you need to enable it. To do that: locate the Manage box at the bottom, click Disabled Items, then click Go. Then, select the Add-In , click Enable , then Close.

More on how to enable a disabled Add-In, see:
https://msdn.microsoft.com/en-us/library/ms268871.aspx

This will enable the Add-in and place it in the In-Active state. proceed to step (b).

b. In-Active.

This screen is showing the CA Agile Central Add-in for Excel in an In-Active state. 
User-added image

To activate the Add-in, select COM Add-Ins in the Manage box at bottom, then click Go.
A window will pop up where you shall see this Add-In unchecked. Simply , check the checkbox of the Add-in and click OK
This will activate the Add-in and make the tab visible in Excel again.

User-added image

 

Cause 2



Make sure that .NET Framework version 4.5 or higher is installed. This is required for the Add-in for Excel versions 2.44 and higher. 
Step 1: Install .NET Framework 4.5 or higher, found at https://www.microsoft.com/en-us/download/details.aspx?id=30653
Step 2: Uninstall the Add-in for Excel
Step 3: Reinstall the Add-in for Excel using the .msi Installer found at https://help.rallydev.com/rally-add-excel-installation-user-guide

User-added image