Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JIRA Cloud for Excel leaves old data in active worksheet

Janusz Pawlinka
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 22, 2023

I'm using JIRA Cloud for Excel version 1.1.0.0 (according to Security Info data) with Excel 365. 

I have a filter to get data from JIRA into active sheet (tab). There is a number of rows imported yesterday to this tab (let's say 65 rows). I know that today i should get 58 rows using the same filter.

When I click "Refresh Data" on JIRA Cloud for Excel panel I get standard warning message: "You are about to replace everything in the active sheet.". I'm OK with this and I click "Continue". The query executes and I see "58 of 58 rows imported in 11 seconds" summary in the panel.

But if I check Excel tab - there is still 65 rows filled - 58 new and 7 leftovers from yesterday's  execution of the query.

Tested on several different spreadsheets and JIRA filters with the same result.

Quick workaround is to clear the active sheet before running query (but it should be done by JIRA Cloud for Excel according to warning message).

It worked fine several weeks ago - any idea what happened?

0 answers

Suggest an answer

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

Atlassian Community Events