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

Dave Thomson November 18, 2024

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

 

 

1 answer

1 accepted

0 votes
Answer accepted
Ashish Bijlwan
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 19, 2024

Hi @Dave Thomson 

Welcome to Atlassian Community!

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

 

Thank you,
Ashish

 

Dave Thomson November 19, 2024

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 21, 2024

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 November 21, 2024

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 November 21, 2024

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

Like Ashish Bijlwan likes this
Ashish Bijlwan
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 21, 2024

Hi @Dave Thomson 

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

 

Thank you,
Ashish

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events