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; } } }

Jira Cloud for Excel updates are very slow and excel prints download slow with many events

Paul M. Brunner

Jira Cloud for Excel is working very slow as possible. I am connecting to the same filter and excel file for over the last year.

When I initiate the update it indicates it is downloading and has downloaded the issues and is saving in the plugin. Excel does not show it is updating in the top bar nor that it had been updated. When I watch the file update it prints the data very slow. When I move the cursor over the data area (during the update) the excel hour glass appears and is flashing.

The closest thing this reminds me of is when using VBA or a lot of macros in excel and events are firing to the point where the update is slowed down due to the event notifications in excel.

Accepted answers

All comments

jack brickey

That is rather odd. How many records are you pulling? Have you tried a simple query on a small Number of issues?

Paul M. Brunner

I am reading ~12,000 issues. It was fast about 2 weeks ago and has slowed down drastically.

jack brickey

That is a sizable query but doable. I have to wonder if it is on the Jira side or the client side

restart excel
restart PC
ask colleague to try it
try other smaller queries

Paul M. Brunner

Hello Jack,

I have done all but ask someone else to do it. The smaller queries are faster, but not what they used to be. I see no other issues in the browser when working with Jira.

I suspect it is in the plug-in. I can ask a colleague to try this week.

Thank You.

Simon Zweifel

had the same issue with 170 records. download seemed to take less than a second, but Excel then remained stuck in "Saving..." for a minute or two.

-> went into "Settings" and turned off "Allow hyperlinks"

It now works like a charm.

caglad

having the same issue - however, I dont think its query or load related. if you click back on the query page (vs the page that is waiting to pop-up which version to download), the query page says "validating". Since its intermittent, and since they just added a default, created tickets in the last 4 week vs all, I think this is a bug or a performance issue with Jira.

brandi.kidd

You're a lifesaver... I've been dealing with this slowness for months before I found your reply!!

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-software-cloud

jira-cloud

ms-excel