@Victoria317
Would reply directly with Noyes. ...You find Microsoft Link, further down.
As far as I know, despite the same file extension, files from different Office versions are not compatible with each other. Even within the same version, but with different update status, the files can differ.
In certain situations strange behavior can occur, especially of Excel documents. One thing is certain, however, there is certainly a topic here that nobody wants to know and nobody wants to admit.
Microsoft does not consistently adhere to the .xlsx format. In particular, there is no compatibility between Excel 2016 and Excel 365 and Excel 2019.
In order not to be misunderstood, for me it is Microsoft Office is very extensive software.
In terms of price, it is the ultimate solution and no normal company could offer such a range of functions at these conditions.
But (and always in my opinion) Microsoft Office, regardless of whether it is Office 365, Office 2019 or even older versions, is from the outset not professional software or industry software in the sense of developing for special solutions.
Some things take your time, but patience is not the virtue of a customer, that's why you can only inquire and the best thing in Microsoft .... you can also suggest that something be changed or added.
Use Excel with earlier versions of Exce
https://support.microsoft.com/en-gb/office/use-excel-with-earlier-versions-of-excel-2fd9ffcb-6fce-48...
Thank you for taking the time to read my comment, I hope that I was able to help you further with this link and information. I would appreciate your feedback.
Wish you a nice day.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
