Agile Central: Excel Add-in 2.4.4 - How to reuse my queries in another Excel instance?
search cancel

Agile Central: Excel Add-in 2.4.4 - How to reuse my queries in another Excel instance?

book

Article ID: 94867

calendar_today

Updated On:

Products

Rally On-Premise Rally SaaS

Issue/Introduction

CA Agile Central provides an Add-in to Microsoft's Excel. This Add-in will help you organize your data.
Using this Add-in you will create filter queries that you can later execute to export Rally data into your Excel spreadsheets. This doc explains how to be able to reuse queries in another Excel installation instance. 

Is there a way to backup my queries in Excel so that they can be loaded into another Excel instance on another machine and reused without the need to manually create them again?

Environment

Release:
Component: ACSAAS

Resolution

The CA Agile Central Add-in for Excel keeps its configuration in this file:

C:\Users\<WindowsUser>\AppData\Roaming\Rally\ExcelAddIn\rallyExcel.xml
(where <WindowsUser> is the profile name of that user that's currently using this Add-in under Excel).

You can use any text editor to view this file. Among other details, this file contains the connection information, the selected workspace and project. Moreover, this file contains the list of queries you created in the CA Agile Central tab including their names, artifacts, fetched columns, order of columns and more.

You shall be able to backup this file occasionally so that you don't lose your info and queries. By that same practice, you can place this file in this location in another Excel instance on another machine, then upon opening that Excel you shall find your queries in the other Excel instance.