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? :)

[Jack Brickey · Accepted solution]

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]

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

[Tina Hannula]

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