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.
This is what I have done with no change.
The plug-in responds within a minute that all 12K issues have been downloaded. The message at the bottom indicates it is saving, but the top of excel shows nothing. This is when I get the hour glass and cursor flashing. I have had occasions where it saves after 15-20 minutes. To manually save the file it takes < 30 seconds.
I have a smaller query, about 2.8K and it runs faster (about 4 minutes), but the behavior is the same.
When the plugin indicates it is saving, the excel worksheet is updating very slowly.
My best guess is it is when "Jira Cloud for Excel" saves the file. It seems to struggle with this.
1) Disabled add-ins.
2) Re-installed office.
3) Re-installed Jira Cloud for excel into excel.
4) I run the same import (using the same filter) in a separate excel workbook. The results were the same.
5) On the smaller queries, < 1K, if I force the save of the workbook when the plug-in indicates its saving it responds with saved.
@Paul M. Brunner I am sorry to hear about issue with Excel add-on, can you please raise a support request with us either through the support site or the in-app support menu? That way we can also easily identify your user details and take a look at your logs to see if the problem occurs at our end or on Excel's end. Based on what you are seeing I would also recommend an additional test, try importing your issues in a completely NEW excel document, does that make things faster?
I'm having this issue now as well... Takes 3 minutes to run a query that returns 127 records with only 18 fields selected. It used to run in seconds.
It seems like the issue is mostly in excel – the little status on the bottom says "x of x records imported. Saving..." and it hangs excel while it's processing the result set.
I'm using Excel on Mac OS.
It's hard to say confidently, as I met Excel users who were able to overcome this issue, but others are still having this and there are no clear indicators of why this is happening.
During our work on a native Jira Cloud Excel exporter solution, we talked to affected users to investigate issues that typically arise to identify a source problem without any luck. Based on their reports, opening a ticket with Atlassian doesn't always yield a solution, either.
Some users are satisfied with Jira Cloud for Excel but if you are not in that group, I would suggest switching from a Microsoft Excel add-in to a native Jira Cloud app like Better Excel Exporter.
If Jira Cloud Excel reporting and exporting is important to your work, it's worth giving a try.
(Please note that Better Excel Exporter for Jira Cloud is a paid and supported app and I'm part of the team developing it.)
👋 Hi there Jira Community! A few months ago we shared with you plans around renaming epics in your company-managed projects. As part of these changes, we highlighted upcoming changes to epics on...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events