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
Community Members
Community Events
Community Groups

Jira Plugin for Excel - Refresh options



I've been using the Jira plugin for Excel to pull data from Jira into Excel and have a question regarding the options to refresh the data offered by the plugin.

When you go to the Updates tab, it gives you two options:

1) Re-run my query each time I open the workbook

2) Only when I click the refresh button

Option 1 is pretty clear but I have a question re option 2 - 

Is the "refresh button" in question referring to the button inside of the plugin that reads "Get Data Now" or is it referring to the actual "Refresh" button from the Data ribbon in Excel?

I have the same plugin running in Google Sheets and the plugin offers scheduling options where you can actually determine how often the plugin runs and refreshes data by specifying the hours interval but the same plugin for Excel lacks that feature so the refreshing options are only the two offered above - which is a bummer.


2 answers

1 accepted

0 votes
Answer accepted

I would be interested in this as well, I'm using the plug-in to provide our customers with an excel view of the tickets that have been raised as we have a Branch/Franchise setup and while the branches are supposed to include the Franchise they tend not too.

In terms of the refresh what I'd specifically like to know is whether or not I need to be the one that opens the workbook or can anyone open it and refresh it.

Im also interested in this. A scheduling option would be cool!

Suggest an answer

Log in or Sign up to answer
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,092 views 34 44
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