Agile Central: Excel add-in - Error: "The control cannot be added because a control with the name RallyQueryResultList already exists in the Controls collection."
search cancel

Agile Central: Excel add-in - Error: "The control cannot be added because a control with the name RallyQueryResultList already exists in the Controls collection."

book

Article ID: 106120

calendar_today

Updated On:

Products

CA Agile Central On Premise (Rally) CA Agile Central SaaS (Rally)

Issue/Introduction



Here is an error we are receiving when trying to use the Excel add-in to run an export query:

<Please see attached file for image>

User-added image

Environment

Release:
Component: ACSAAS

Resolution

The root cause for this problem has not been identified.

However, this error dialog message pops up when the add-in can not export the query cause the object to list the content is already in-use. This problem always happens after a query was already run via excel export.

Please perform these steps in this order and it should allow you to continue. Please run your export query after each step. 
Continue to the next suggested step only if unsuccessful. If successful then you have cleared the object and you can continue.

1. Open up a new spread sheet in your excel file and run the query there.

2. Delete the spread sheet where you ran the export that caused this error message.

3. Reconnect the Excel add-in to CA Agile Central.

4. Close the Excel file, then reopen the file.

5. Open an entirely new Excel file.

Additional Information

On Excel add-in download and install: https://help.rallydev.com/rally-add-excel-installation-user-guide

Using the Excel add-in: https://help.rallydev.com/rally-add-excel

Further reading on known issues and questions on the Excel add-in: 
https://support.ca.com/us/product-information/ca-agile-central.html?type=ALL&q=excel%20add-in

Attachments

1558699604600000106120_sktwi1f5rjvs16js7.png get_app