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 * Spreadsheet 1 should match with JQL Query 1 * 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

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Spreadsheet 1 should match with JQL Query 1
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

Accepted answers

Ashish Bijlwan_zogaqs

Hi @Dave Thomson

Welcome to Atlassian Community!

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

Thank you,
Ashish

All comments

Ashish Bijlwan_zogaqs

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_zogaqs

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-cloud

ms-excel

query

excel