Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,299,594
Community Members
 
Community Events
165
Community Groups

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

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.

1 answer

0 votes
Jack Brickey Community Leader Sep 04, 2021

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

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

Jack Brickey Community Leader Sep 05, 2021

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

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.

This is what I have done with no change.

 

BEHAVOIR DETAIL:

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.

 

ACTIONS TAKEN:

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. 

 

 

 

Jack Brickey Community Leader Sep 07, 2021

An interesting test might be to use Google sheets and the associated addon for that. This would help identify if it’s something that’s running Jira itself that is slow or if it’s Excel and its associated addon.

I am unable to use google sheets due to internal security limitations.

Jack Brickey Community Leader Sep 07, 2021

I guess I would recommend Atlassian support at this point. As I am unable to reproduce the problem myself.

@Rahul Patil can you help with this please. You have previously provided help with this tool for me. Thanks.

Rahul Patil Atlassian Team Sep 07, 2021

@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?

Hi Paul,

Do you have any updates on this?  I have been experiencing the same slowdowns starting around the same time as your original message.

 

Thanks,

Like Paul M. Brunner likes this

I raised the issue to the support team through the app. They contacted me and I provided information. I would suggest you also enter a ticket so they are aware it is not unique to me.

 

BTW, I did reference this posting in my response as part of my information.

Like Blake Bartok likes this

any luck?  they have been working on this issue with me but no success yet.

@Blake Bartok have you received any reply to your issue? Did they solve this eventually?

@Blake Bartok I have received no updates to this issue. How about your.

Like Levente Szabo _Midori_ likes this

@Paul M. Brunner @Blake Bartok Have your issues already been addressed and solved by Atlassian?

@Levente Szabo  seems to be working well for me now

@Levente Szabo _Midori_  I raised a support question with Atlassian and have had no response. Very disapointed.

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.

multi-issue-excel-export-menu-cloud-noannotation.png

(Please note that Better Excel Exporter for Jira Cloud is a paid and supported app and I'm part of the team developing it.)

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Software

Upcoming changes to epic fields in company-managed projects

👋 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...

14,986 views 37 49
Read article

Community Events

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

Events near you