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

Can I set Excel "Get Jira Data" to run automatically?

Tina Hannula

Newbie to this Excel/Jira Cloud game & not an administrator.

I am pulling data from Jira to populate an excel spreadsheet. I have a file that snags the data from Jira when I ask it to, but I'd like to automate it. The option to "Re-run my query each time I open workbook" doesn't work when I open the file or with a check-out--it seems I have to actually hit the "Get Jira Data" button every time, then click the "Refresh Data" button. Am I missing something somewhere?

Accepted answers

Jack Brickey

Not with excel but Google sheets allows scheduling - jira-cloud-for-google-sheets-official

All comments

Tina Hannula

CORRECTION: I don't have to hit the "Refresh Data" button, just the "Get Jira Data" button.

Jack Brickey

Not with excel but Google sheets allows scheduling - jira-cloud-for-google-sheets-official

Tina Hannula

I saw that ability and was hoping it would have been available on Excel, too. Thank you!

Jeremy Patterson_e9cuho

Did you ever find an answer for Excel?

Yatish Madhav

HI - I am looking for the solution to this too. I am personally not much of a Microsoft fan and this is fueling that fire (esp if Atlassian is able to do so with Google Sheets and not Microsoft Excel)

Please let me know if anyone found a way on this. Thanks in advance.

Mateus Haubert

Hi @Tina Hannula , how did you make Excel populate with data from Jira by hitting a button? I'm interested on this solution, even if the user has to manually trigger it. Thanks

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud

export

ms-excel

ms-office-365