It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Exported Excel file cannot be opened because the file format or file extension is not valid in Win10 Edited

We used to be able to export issues to Excel file format from the Jira Issue Navigator (search and filters). After our company upgraded our PCs to Windows 10 and Office 365 few months ago, we are no longer able to open the Excel files exported from Jira.  We're running Jira Server 7.10.2.

The error message encountered is:

"Excel cannot open the file 'XXXXXXX.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file."

Is Jira exporting to Excel format which is office 97-2003?

JRASERVER-62196 - Filter result Excel(XLS) export is not usable anymore, need XLSX format support

JRASERVER-60667 - File format does not match extension

 

I have searched but could not find a suitable solution.  I have tried to rename the file extension, open in safe mode, open and repair, all to no avail. 

Has anyone else experienced the same problem?  Is there a way to fix this problem?

 

Regards,
Marianne

2 answers

0 votes
Joe_Pitt Community Leader Jan 06, 2020

Open excel and go to the options/trust center/trust center settings/file block settings and look for any file for some earlier versions of excel being blocked. I had a similar problem where older versions of excel were blocked for security reasons. 

Thanks, @Joe_Pitt I'm checking that with the Windows group in the operations team, I've not got any reply yet.

0 votes

It's an older story. The problem is that the "xlsx" file exported from Jira is actually an HTML file with a table, which older Excel versions were able to import. So it was never a native Excel file, but the file extension instruction Excel to import it. Then, Microsoft disallowed this trick for security reasons.

There are every sort of hacky workarounds, or there is the Better Excel Exporter app that produces real Excel files.

(Disclaimer: I am developer of this paid app.)

jira-issues-selected-fields

Thanks @Aron_Gombas__Midori_ I found out that export to Excel format had been deprecated long time ago since Jira 7.2. Will advise my users to use other available formats.

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you