Are excel files saved in excel 365 compatible to opening in excel 2016

%3CLINGO-SUB%20id%3D%22lingo-sub-1725412%22%20slang%3D%22en-US%22%3EAre%20excel%20files%20saved%20in%20excel%20365%20compatible%20to%20opening%20in%20excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1725412%22%20slang%3D%22en-US%22%3E%3CP%3EAre%20excel%20files%20saved%20in%20excel%20365%20compatible%20to%20opening%20in%20excel%202016%3F%20When%20I%20open%20a%20file%20in%20excel%202016%20that%20was%20previously%20saved%20in%20excel%20365%2C%20this%26nbsp%3Berrors%20occur%2C%20We%20found%20a%20problem%20with%20some%20content%20in%20...%20Do%20you%20want%20us%20to%20try%20to%20recover%20as%20much%20as%20we%20can%3F%26nbsp%3B%20After%20selecting%20yes%2C%20this%20message%20occur%2C%20Removed%20Part%3A%20%2Fxl%2FprinterSettings%2FprinterSettings10.bin%20part.%20(Print%20options).%20How%20should%20the%20document%20be%20saved%20in%20excel%20365%20to%20allow%20opening%20without%20errors%20in%20excel%202016%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1725412%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1725530%22%20slang%3D%22de-DE%22%3ESubject%3A%20Are%20excel%20files%20saved%20in%20excel%20365%20compatible%20to%20opening%20in%20excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1725530%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F813594%22%20target%3D%22_blank%22%3E%40Victoria317%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EWould%20reply%20directly%20with%20Noyes.%3C%2FSPAN%3E...You%20find%20Microsoft%20Link%2C%20%3CSPAN%20class%3D%22%22%3Efurther%20down%3C%2FSPAN%3E.%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3EAs%20far%20as%20I%20know%2C%20despite%20the%20same%20file%20extension%2C%20files%20from%20different%20Office%20versions%20are%20not%20compatible%20with%20each%20other.%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3EEven%20within%20the%20same%20version%2C%20but%20with%20different%20update%20status%2C%20the%20files%20can%20differ.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3EIn%20certain%20situations%20strange%20behavior%20can%20occur%2C%20especially%20of%20Excel%20documents.%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3EOne%20thing%20is%20certain%2C%20however%2C%20there%20is%20certainly%20a%20topic%20here%20that%20nobody%20wants%20to%20know%20and%20nobody%20wants%20to%20admit.%3C%2FSPAN%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EMicrosoft%20does%20not%20consistently%20adhere%20to%20the%20.xlsx%20format.%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3EIn%20particular%2C%20there%20is%20no%20compatibility%20between%20Excel%202016%20and%20Excel%20365%20and%20Excel%202019.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22text-wrap%20tlid-copy-target%22%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EIn%20order%20not%20to%20be%20misunderstood%2C%20for%20me%20it%20is%20%3C%2FSPAN%3EMicrosoft%20Office%20is%20very%20extensive%20%3CSPAN%20class%3D%22%22%3Esoftware.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EIn%20terms%20of%20price%2C%20it%20is%20the%20ultimate%20solution%20and%20no%20normal%20company%20could%20offer%20such%20a%20range%20of%20functions%20at%20these%20conditions.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3EBut%20(and%20always%20in%20my%20opinion)%20Microsoft%20Office%2C%20regardless%20of%20whether%20it%20is%20Office%20365%2C%20Office%202019%20or%20even%20older%20versions%2C%20is%20from%20the%20outset%20not%20professional%20software%20or%20industry%20software%20in%20the%20sense%20of%20developing%20for%20special%20solutions.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3ESome%20things%20take%20your%20time%2C%20but%20patience%20is%20not%20the%20virtual%20of%20a%20customer%2C%20that's%20why%20you%20can%20only%20inquire%20and%20the%20best%20thing%20in%20Microsoft%20....%20You%20can%20also%20suggest%20that%20something%20is%20changed%20or%20added.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22tlid-result-transliteration-container%20result-transliteration-container%20transliteration-container%22%3E%3CDIV%20class%3D%22tlid-transliteration-content%20transliteration-content%20full%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3CH1%20id%3D%22toc-hId-554259758%22%20id%3D%22toc-hId-554259758%22%3E%3CFONT%20size%3D%224%22%3EUse%20Excel%20with%20earlier%20versions%20of%20Exce%3C%2FFONT%3E%3C%2FH1%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Foffice%2Fuse-excel-with-earlier-versions-of-excel-2fd9ffcb-6fce-485b-85af-fecfd651a5ac%3Fui%3Den-us%26amp%3Brs%3Den-gb%26amp%3Bad%3Dgb%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CFONT%20size%3D%224%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Foffice%2Fuse-excel-with-earlier-versions-of-excel-2fd9ffcb-6fce-485b-85af-fecfd651a5ac%3Fui%3Den-us%26amp%3Brs%3Den-gb%26amp%3Bad%3Dgb%3C%2FFONT%3E%3C%2FA%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22text-wrap%20tlid-copy-target%22%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EThank%20you%20for%20taking%20the%20time%20to%20read%20my%20comment%2C%20I%20hope%20that%20I%20was%20able%20to%20help%20you%20further%20with%20this%20link%20and%20information.%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3EI%20would%20appreciate%20your%20feedback.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22tlid-result-transliteration-container%20result-transliteration-container%20transliteration-container%22%3E%3CDIV%20class%3D%22tlid-transliteration-content%20transliteration-content%20full%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22tlid-transliteration-content%20transliteration-content%20full%22%3E%3CP%3EWish%20you%20a%20nice%20day.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%222%22%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FFONT%3E%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Are excel files saved in excel 365 compatible to opening in excel 2016? When I open a file in excel 2016 that was previously saved in excel 365, this errors occur, We found a problem with some content in ... Do you want us to try to recover as much as we can?  After selecting yes, this message occur, Removed Part: /xl/printerSettings/printerSettings10.bin part. (Print options). How should the document be saved in excel 365 to allow opening without errors in excel 2016?

2 Replies
Highlighted

@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.

 

 

Highlighted

@Victoria317 

365 and 2016 are not fully compatible, but your error is most probably related to different network environment and/or printer driver settings. 

Not sure how to fix, try to play with default printing settings.