Why is Office Excel having issues in using xlxs files but not with xls

Jake Robert Ventura
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!
October 2, 2024

Hi, I have observed that using the same file with the exact same data, there's a high chance that using xlsx files have a tendency to spawn the error below: 

 

We can't preview this file. You'll have to download the file to view it.

 

This is also most likely to happen when your file is 2MB or more.

Then when you convert your file to xls and used it in Office Excel, it works just fine. Is there a reason why this is happening ?

1 answer

1 accepted

0 votes
Answer accepted
Lucas Modzelewski _Lumo_
Atlassian Partner
October 4, 2024

Hi @Jake Robert Ventura , welcome to the Atlassian Community!

I've checked with Chat GPT, and basically .xlsx is more complex, here is part of the looong response:

 

  • XLSX is a more complex and modern format that is XML-based and typically compressed in a zip-like structure. When dealing with large files, especially those over 2MB, this complexity can make it harder for some applications or web-based viewers to process the file for preview.
  • XLS, on the other hand, is an older, binary format. It is less complex than XLSX and often simpler for programs to read or preview, especially for larger file sizes, despite XLS files generally being larger in size.

 

It looks like long time ago there was an issue with .xlsx files > 2MB previews on Confluence:

https://jira.atlassian.com/browse/CONFCLOUD-25709 

Jake Robert Ventura
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!
October 4, 2024

Thank you @Lucas Modzelewski _Lumo_ !  Using chat gpt did not even crossed in my mind but the explanation makes a lot of sense. 

It also seems like this is something that has been long accepted considering the link you've shared was from 2016.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events