JQL Query Is Overwritten When Using The Jira Excel Plugin in 2 Separate Spreadsheets

[Dave Thomson]

Hi,

Summary - I'm using the Jira Cloud plugin for MSExcel and my JQL queries in separate spreadsheets are being overwritten with the last query i have run.

Background

I am working with 2 separate excel spreadsheets that are querying the same Jira data.

Each spreadsheet was created with its own unique JQL query, eg

1. Spreadsheet 1 should match with JQL Query 1
2. Spreadsheet 2 should match with JQL Query 2

but... I have the following scenario

• I run query 1 on spreadsheet 1 and as expected the data refreshes ok.
• I save and close spreadsheet 1.
• I open spreadsheet 2 and query 2 is now replaced with query 1 in the JQL Query box
• If I were to refresh the data without thinking it would run query 1 and wipes out the data previously retrieved using query 2.
• This also happens vice versa, the last query run is retained, regardless of the spreadsheet I'm using.

My workaround is to keep text copies of the queries and paste them in the query box every time I switch between spreadsheets.

They are stored in separate locations.

Is there a solution to this?

Many Thanks

Dave

[Ashish Bijlwan · Accepted solution]

Hi @Dave Thomson 

Welcome to Atlassian Community!

Please save the spreadsheet in .xlsx format with different name.

Thank you,
Ashish

[Dave Thomson]

Hi @Ashish Bijlwan ,

Thanks for the welcome and quick response.

Both files were already in .xlsx format.  Ive renamed them and also moved one of them to my local device to ensure they were not in the same location.

Same issue occurs, I updated the data in file 1, saved it, closed it, and opened the 2nd file.  The queries from file 1 are populating the JQL Query box in the 2nd file and I'm having to copy and paste the correct queries into file 2 before refreshing the data.

Thanks

[Ashish Bijlwan]

Hi @Dave Thomson 

I hope Spreadsheet 2 is not a copy of Spreadsheet 1 because there is a link between the two excel spreadsheets under the covers in the Jira Cloud data link. And if it's a copy then try to Create New spreadsheet and add the JQL. This will solve the issue.

Kindly try and confirm.

Thank you,
Ashish 

[Dave Thomson]

Hi @Ashish Bijlwan ,

Thanks again for the follow up.  That is a great shout, one file is a copy of the other.  I'll create a 2nd sheet 'as new' and hopefully that resolves it.

Cheers

Dave

[Dave Thomson]

Hi @Ashish Bijlwan ,

Result!!!

Building the spreadsheet and the queries from scratch has resolved it.  Lesson learned for future work :)

Many thanks again for your help and support, really appreciate it.

Have a great Friday!

Dave

[Ashish Bijlwan]

Hi @Dave Thomson 

Great to hear that. You too have a great Friday!

Thank you,
Ashish