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.
Perform the following step in case you don't see a CA Agile Central tab in Excel:
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.
In the Windows registry, locate the following path:
You shall see these keys and values in that path:
"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..."
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.
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:
This will enable the Add-in and place it in the In-Active state. proceed to step (b).
This screen is showing the CA Agile Central Add-in for Excel in an In-Active state.
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.
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