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

Unable to open xls exported file

ATI PV

Hello,

From any session or accounts, after exporting and creating the xls file from a filter, MS-Excel is not able to open the file. The file looks well created with normal size, however the sheet can not be loaded by the excel application.

Few days ago, the function was working fine.

Thx for your support.

André

PB export JIRA.xls

Accepted answers

Martin Cvrček

For view file originating from the Internet see also https://answers.atlassian.com/questions/39432356

Open an Excel sheet
Navigate to File -> Options -> Trust Center -> Trust Center Settings -> Protected View
Un-Check "Enable Protected View for file originating from the Internet".

(thanx Bryan Trummer)

All comments

Nic Brough -Adaptavist-

Is this for Cloud or Server?

Have you created or changed the configuration of any custom fields that are being exported? Can you try an "export only current fields" on a really simple issue navigator showing maybe just key, summary and description?

Can you open the .xls in a text editor and check that it looks valid in there? (it's not actually an excel file, it's xml that says "I'm a spreadsheet" so that any spreadsheet can open it if it understands xml)

Anne-Sophie DARNAND

Hi,

I have the same problem.

This is for Cloud.

I can send you a example on a really simple issue if you want. I can open it in a text editor but it's impossible with excel.

Me too, few days ago, the function was working fine.

Thanks for your support.

Anne-Sophie

Nic Brough -Adaptavist-

Ok, does the xml look valid in there? Any odd characters? Check it with some form of xml validation tool?

Anne-Sophie DARNAND

Martin Cvrček

For view file originating from the Internet see also https://answers.atlassian.com/questions/39432356

Open an Excel sheet
Navigate to File -> Options -> Trust Center -> Trust Center Settings -> Protected View
Un-Check "Enable Protected View for file originating from the Internet".

(thanx Bryan Trummer)

John Tisaranni

See if you have installed the following Excel updates. I noticed this problem right after these were installed and it no longer occurs for me after they were removed.

This is a report of this issue on answers.microsoft.com that ties it to KB3115322 with a recommended work-around that does not require removing the update.

Christine Meyer

The work around worked for me - I had exactly the same issue - thank you very much!

ATI PV

First I apologize for the delay of answer. It was a long weekend holiday smile

And many thanks to all, it is working fine now thank to your answers.

André

ATI PV

Many thx. André

Midori

Those who'd prefer an actual solution where you can keep exports secure without turning off security checks in Excel, should check out the Better Excel add-on.

In a nutshell: it exports real XLSX files, therefore Excel "opens these in a secure way" (plus offers a lot of advantages in comparison to the files created by the built-in Excel export feature).

Mahindra

Thanks a lot. It works.

Michael Pendelt

Probably the problem might be in xls corrupted file

Welcome!

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

Quick Links

Find more posts tagged with

jira

jira-software

export

ms-excel