ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Agile Central: Excel add-in - Error: "The control cannot be added because a control with the name RallyQueryResultList already exists in the Controls collection."
Article ID: 106120
CA Agile Central On Premise (Rally)CA Agile Central SaaS (Rally)
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>
Release: Component: ACSAAS
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.