Getting Pivot Table Range Conflct when trying to refresh data in Excel using JIRA Excel plugin.

William Powers
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 2, 2024

I'm receiving this error message when refreshing the Jira cloud add in for Excel.  This only happens when I run it the refresh data from the tab with pivot tables.  The refresh data works on the data tabs.

I need this to work on the Pivot Table tab since that is what my stakeholders see.

 

I've verified that none of the pivot tables are at risk of overlap.

Data refresh is set up with JQL query of project = project name and max rows = 10,000 

 

1 answer

0 votes
Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
June 6, 2024

Hi @William Powers

unfortunately I can't comment on why you're receiving an error here. Our friends at Midori put together this guide for resolving common problems with the integration, and also offer a great alternative through the Atlassian Marketplace - perhaps there's something useful in there? 

Alternatively, as the Excel integration is operated by Atlassian, you may want to consider reaching out to Atlassian Support.

Best,

Hannes

Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
June 6, 2024

... and just as food for thought: Depending on your exact use case, you may even want to consider whether you need to sync back and forth between Jira and Excel at all, or whether you could do all your work in directly within Jira.

E.g., you may want to have a look at the app that my team and I are working on, JXL for Jira. It's a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. JXL also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

With these, you can build a view like e.g. this in just a couple of clicks:

report-1.gif

This is really just one of a virtually endless number of possible views and reports - you could also view, group by, and sum up any other issue field(s), configure different sum-up styles, etc. etc.

This all happens directly in Jira, using your Jira data - so whatever you chose to do in JXL, your view is always live and fully synchronised. 

Any questions just let me know!

Suggest an answer

Log in or Sign up to answer