Office 2024 vs Office 2021: What Actually Changed
If you are choosing between Office 2024 and Office 2021, the honest summary is that 2024 is an evolution, not a redesign. Most of what you use daily looks and behaves the same. The differences that matter are concentrated in Excel, a handful of smaller additions elsewhere, one removal, and, more than any feature, the support dates.
This article is part of our series on Office 2024 Professional Plus LTSC, which explains what the edition is and who it suits.
The support dates come first
Features are the least important difference, so start with the calendar.
- Office LTSC 2024 is supported through October 2029: five years of mainstream support, with no extended support after that.
- Office 2021 support ended on October 13, 2026. Microsoft no longer issues security updates for it.
A license for Office 2021 keeps working. What stops is the flow of security fixes, and Office is one of the most targeted applications on any machine because it opens files sent by strangers. For a business that handles customer email and attachments, that is the single strongest argument for the newer version.
Microsoft publishes the dates for every version on its lifecycle pages, and they are worth checking for any Office version you are running today.
What is new in Excel
Excel gets the biggest upgrade, and if your team lives in spreadsheets this is where the value is.
- Fourteen new text and array functions, including TEXTSPLIT, TEXTBEFORE, TEXTAFTER, VSTACK, HSTACK, TAKE, DROP and CHOOSECOLS. They replace long chains of older formulas with one readable call. Splitting a column of "Last, First" values used to take several nested functions. It is now a single TEXTSPLIT.
- Dynamic charts: charts can reference dynamic arrays, so a chart grows and shrinks with the data behind it instead of needing a manual range edit.
- The IMAGE function, which pulls a picture from a web address straight into a cell, useful for product sheets and catalogs.
- Faster workbooks, which Microsoft lists among the improvements.
One removal to know about: the "Publish to Power BI" option is gone from Excel in LTSC 2024. Microsoft points users to the Power BI service instead.
What is new elsewhere
| App | What changed |
|---|---|
| PowerPoint | Present with your camera feed (Cameo), record a video in Recording Studio, embed videos from Stream, closed captions for video and audio |
| Outlook | Better search across mail, calendar and contacts, more options when creating meetings, such as ending early or starting late |
| Word | Session recovery: documents reopen after an unexpected close |
| OneNote | Improved Draw tab and ink features |
| Access | Dataverse connector for Power Platform |
| All apps | A new default theme, accessibility improvements, OpenDocument format 1.4 support |
Microsoft publishes one shared list for Office 2024 and Office LTSC 2024, and a few items on it are described for the consumer edition. If a specific feature is the reason you are buying, check Microsoft's current "What's new" page for that item before you order.
What was removed: Publisher
Publisher is not included in Office 2024. Microsoft is retiring the application. If your business uses Publisher for flyers, price lists or labels, you have three realistic options: keep an Office 2021 install for that purpose, move the documents to Word or PowerPoint, or use a dedicated design tool. Do not assume your existing Publisher files will open in the new suite.
If you do not use Publisher, you will not notice its absence.
Compatibility is not a worry
Both versions are major version 16, the same as Office 2019, which means add-ins and macros that work on Office 2021 are very likely to work on 2024 with minimal testing. Files move between the two without conversion.
So which one?
| Your situation | Recommendation |
|---|---|
| Buying new, no Publisher dependency | Office 2024 Professional Plus LTSC |
| Heavy Excel use | Office 2024: the new functions pay for themselves |
| You depend on Publisher | Plan the migration first, then buy 2024 |
| Already on 2021 with no problems | Support has ended, so schedule the move, no rush on the day |
For machines that need the longest remaining support window, the answer is the newer version. Our Office 2021 Professional Plus remains available for the Publisher case and for machines that must match an existing standard.
Next in the series: whether to buy once at all, in Office license versus Microsoft 365.