Office 2019 Compatability with Office 2016

JERRY89
4StarLounger
Posts: 446
Joined: 21 Feb 2016, 02:52

Office 2019 Compatability with Office 2016

Post by JERRY89 »

Dear All,

Is Office 2019 compatible with Office 2016, I ask this due to my company are having 40 PC under Microsoft Office 2016 but wanted to purchase 5 PC with Office 2019 so will it be any issue for the file created in this 5 PC cant be open in the other Office 2016 PC or will it have any major impact?

User avatar
HansV
Administrator
Posts: 69412
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Office 2019 Compatability with Office 2016

Post by HansV »

They use the same file format, and the differences are small. But there are some things to keep in mind.

For example, Excel 2019 has a few new worksheet functions, such as IFS, SWITCH and TEXTJOIN. If you use such a function in Excel 2019, save the workbook and then open the workbook in Excel 2016, the function won't be recognized.
Regards,
Hans

JERRY89
4StarLounger
Posts: 446
Joined: 21 Feb 2016, 02:52

Re: Office 2019 Compatability with Office 2016

Post by JERRY89 »

Hi Hans,

Good Day,

Really appreciate it, this is a very great information for me. Thanks you so much, your knowledge in Microsoft is truly amazing. :thankyou: :cheers: