Share via

Excel in Office 2021 compatibility

Anonymous
2022-07-05T08:30:48+00:00

Hi!

I am currently using Office 365 and Office 2019.

I have built some excel models using Office 365 and found that it cannot be run in Office 2019. For example, formula XLOOPUP is not supported in Office 2019.

In general upgrading Office to newer version (say 2013 -> 2017 -> 2019 -> 2021) should not have any compatibility issue.

May I know if Office 365 -> 2021 is the same case?

(My main concern is whether my excel model built in Office 365 is fully supported in Office 2021.

Thanks!

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2022-07-06T09:25:52+00:00

Dear Terrence,

Good day! Thank you for posting in Microsoft Community. We are happy to help you.

If you use Office 2021, you will get Classic 2021 versions of Word, Excel, PowerPoint and Outlook. But if you have Microsoft 365, you will get the 365 versions of these apps.

Currently, there's no major distinction between them in terms of features, and Office 2021 has almost all features released in Microsoft Office 365. So if you switch to Excel 2021 you will be able to use the features of Excel 365.

However, with the Classic 2021 version, you won't get any further updates or new features in the future.

Sincerely,

Igor | Microsoft Community Moderator

***Note: In the event that you're unable to reply to this thread, please ensure that your Email address is verified in the Community Website by clicking on Your Account Name > "My Profile" > "Edit Profile" > Add your Email Address > tick "Receive email notifications"

Was this answer helpful?

2 people found this answer helpful.
0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-07-06T02:08:09+00:00

    Thanks Norman!

    I have similar finding too. So in future if there are new features in Excel 365, Office 2021 cannot support.

    But given that current Excel 2021 is the latest version, for previously built excel model using Excel 365, may I know if it is in general can be run by Excel 2021?

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2022-07-05T09:16:02+00:00

    Hi Terrence,

    I am currently using Office 365 and Office 2019.

    I have built some excel models using Office 365 and found that it cannot be run in Office 2019. For example, formula XLOOPUP is not supported in Office 2019.

    In general upgrading Office to newer version (say 2013 -> 2017 -> 2019 -> 2021) should not have any compatibility issue.

    May I know if Office 365 -> 2021 is the same case?

    (My main concern is whether my excel model built in Office 365 is fully supported in Office 2021.

    See the Microsoft Support article What's the difference between Microsoft 365 and Office 2021?

    In brief, Excel 365 will have the latest functionality and features, unlike Excel 2021 or earlier standalone versions.

    In consequence, if you use new Excel 365 features or functions, these will not be recognised by Excel 2021.

    ===

    Regards,

    Norman

    Immagine

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2022-07-06T14:13:10+00:00

    Hi Igor,

    Thank you very much for your reply!

    Totally understand now!

    Was this answer helpful?

    0 comments