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

Jira Cloud for Excel Functions stopped working

jbruno

I have some VBA that creates a new spread sheet, then pops in a Jira function

Here is an example.

=@JIRA.JQL("project = CLIENT and issuetype = 'Client' order by summary","key, summary, status, linked issues",,)

The plug-in worked beautifully. It would grab the data, everything was right in the world.

Then it stopped working. I had someone else at my company try it, it doesn't work for them either.

It looks like it is trying to import data, but just does nothing.

I am able to open a new sheet and click the 'Get Data Now' and have it pull in data, so I know I can connect to Jira.

And yes...

1. I did try a different copy of my workbook

2. Rebooted

3. Made sure it wasn't just me.

4. Rebooted again.

5. Googled

Thanks for the help!

Accepted answers

All comments

jbruno

A little more information.

The desktop version is still not working. I tried uninstalling / reinstalling the plug in. No dice.

I was able to get the data by using the online version of Excel, then opening the data backup in the desktop and running my macros.

Antony Watson

Anyone got a how to downgrade plan?

Randy Jones_2ngwyo

it is in the temp folder

Dario B

Hello,

Just to double-check, since a similar issue was fixed on the 24th of June:

JIRA Add-in for Excel stopped working

Can you kindly let me know if you are still facing the issue or if it is already solved?

Cheers,
Dario

jbruno

Hi Dario,

It's still broken.

Thanks,

Joel

Dario B

Hello @jbruno ,

I spoke to the app developers and they said:

The JIRA.JQL() function is only working if the app is opened.

According to the error message the user should open the task pane with our app, then activate JIRA.JQL() function.

Firstly the user has to run JIRA.JQL() manually and then try to use VBA.

If this does not help, please ask them to report a bug using the in-app form:

I hope this helps.

Cheers,
Dario

jbruno

Thanks @Dario B ,

I just logged a bug request. (PIF-4535)

As I mentioned in the original post, I had it all up and running perfectly for myself and others in my organization. Then I came in on a Monday morning and it stopped working for everyone.

Let's see what other information your development team needs.

Thanks again,

Joel

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-software