Rally : Excel - Why there is no CA Agile Central tab after installing the Excel Add-in 2.4.4
search cancel

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


Article ID: 94858


Updated On:


Rally On-Premise Rally SaaS


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:

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:


Component: ACSAAS


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:

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.

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.

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.

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

b. In-Active.

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.

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