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

Document ID : KB000094867
Last Modified Date : 07/05/2018
Show Technical Document Details
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. 

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
Question:
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?
Answer:
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.