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?
Office 2019 Compatability with Office 2016
-
- 4StarLounger
- Posts: 516
- Joined: 21 Feb 2016, 02:52
-
- Administrator
- Posts: 78457
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Office 2019 Compatability with Office 2016
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.
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.
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 516
- Joined: 21 Feb 2016, 02:52
Re: Office 2019 Compatability with Office 2016
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.
Good Day,
Really appreciate it, this is a very great information for me. Thanks you so much, your knowledge in Microsoft is truly amazing.