Short answer: In Office 2021 vs 2024, we'd choose the 2024 suite. It adds LAMBDA and 14 new Excel functions. PowerPoint gets Recording Studio and Cameo, and Word gets session recovery. Publisher is gone from the newer one. Both are one-time purchases.
The gap between Office 2021 vs 2024 turns out smaller than most reviews suggest. We get new Excel functions such as LAMBDA and IMAGE, Recording Studio for slides and session recovery for documents. Publisher is dropped. XLOOKUP and dynamic arrays? Already in 2021. We set them side by side below.
- Released: 2021 in October 2021, 2024 on 1 October 2024.
- Excel: the new functions and dynamic charts are 2024 only.
- PowerPoint: Cameo and Recording Studio arrive in 2024.
- Editions: 2024 has Home and Home & Business; Publisher is gone.
- Copilot: in neither; it’s a Microsoft 365 feature.
XLOOKUP, dynamic arrays, LET and real-time co-authoring already arrived in 2021. Neither version has Copilot.
Here’s the full comparison, without the marketing.
| Point | What to know |
|---|---|
| Office 2021 | Released October 5, 2021 |
| Office 2024 | Released October 1, 2024 |
| License | Both are one-time purchases with no feature updates after launch |
| New in 2024 | LAMBDA, IMAGE and 14 new text and array functions in Excel; Cameo and Recording Studio in PowerPoint; session recovery in Word; a new look; OpenDocument Format 1.4 |
| Dropped in 2024 | Publisher; the Teams app isn’t preinstalled. Access remains in Professional Plus |
| Files | Fully compatible: both use version 16.0 and the same DOCX, XLSX and PPTX formats |
Office 2021 vs 2024 at a glance
Both are perpetual, buy-once versions of Microsoft Office.
| Item | Office 2021 | Office 2024 |
|---|---|---|
| Consumer release | October 5, 2021 | October 1, 2024 |
| LTSC release, for business | September 2021 | September 2024 |
| Consumer editions | Home & Student, Home & Business, Professional | Home, Home & Business |
| XLOOKUP, LET, dynamic arrays | Yes | Yes |
| LAMBDA, IMAGE, TEXTSPLIT, VSTACK | No | Yes |
| Dynamic charts from array formulas | No | Yes |
| PowerPoint Cameo and Recording Studio | No | Yes |
| Word session recovery | No | Yes |
| OpenDocument format | ODF 1.3 | ODF 1.4 |
| Publisher | Professional and Professional Plus | Not included |
| Copilot AI | No | No; Microsoft 365 only |
The newer release adds and removes. Publisher is the removal most people notice.
What’s new in the 2024 release
The additions sit on top of what 2021 had.
| App | What it gets |
|---|---|
| Excel | LAMBDA, IMAGE, 14 text and array functions, dynamic charts and pictures in cells |
| PowerPoint | Cameo, Recording Studio and captions |
| Word | Session recovery |
| Outlook | Better search and meeting options |
| All apps | A new theme, accessibility tools and ODF 1.4 |
Excel
Excel is the app with the most new tools. Microsoft lists these additions over Excel 2021.
| Addition | What it does |
|---|---|
| LAMBDA | Lets you create your own reusable functions from ordinary formulas, without VBA |
| 14 text and array functions | TEXTBEFORE, TEXTAFTER, TEXTSPLIT, VSTACK, HSTACK, TOROW, TOCOL, WRAPROWS, WRAPCOLS, TAKE, DROP, CHOOSEROWS, CHOOSECOLS and EXPAND |
| IMAGE function and pictures in cells | Product photos or logos that sort and filter with the row |
| Dynamic charts | Resize when a dynamic array result grows or shrinks |
| Accessibility ribbon | Groups the fixes the checker suggests |
| Faster workbooks | Especially when several open workbooks calculate at once |
Two removals generally matter more for business users.
- Publish to Power BI is gone from Excel 2024. You upload workbooks in the Power BI service.
- Excel blocks untrusted XLL add-ins by default.
From a spreadsheet user’s seat, TEXTSPLIT and VSTACK are often the everyday wins.
Splitting “Last, First” names used to need Power Query or a helper column. So did stacking twelve monthly sheets into one table. In Excel 2024 it’s one formula.
Word
Word 2024 brings session recovery. It reopens every document that was open when Word or Windows closed unexpectedly.
| Also new in Word 2024 | Detail |
|---|---|
| Photos from a phone | Straight from an Android phone on Windows, or from an iPhone through Continuity Camera on Mac |
| Comment reactions | React to a comment with a Like |
| Accessibility | Improved tools |
Dark mode and Line Focus were already in Word 2021.
PowerPoint
| Addition | What it does |
|---|---|
| Cameo | Places a live camera feed inside a slide |
| Recording Studio | Records a whole presentation or single slides as a video, with your camera and ink |
| Captions | Closed captions and subtitles for video and audio |
| Stream videos | Embeds Microsoft Stream videos stored on SharePoint |
Reuse Slides and ink replay arrived in 2021.
The other apps
| App | Change |
|---|---|
| Outlook 2024 for Windows | Improved search across mail, attachments, contacts and calendar, plus meeting options that shorten meetings automatically |
| Outlook 2024 for Mac | Scheduled send and Focused Inbox |
| OneNote LTSC 2024 | A better Draw tab and ink tools |
| Access 2024 | A Dataverse connector for Power Platform |
| Visio 2024 | More shapes, stencils and templates |
For the diagram app, see our Visio 2024 page.
Changes across the whole suite
- A new default Office theme based on Fluent Design.
- OpenDocument Format 1.4 in the three main apps. The 2021 suite used ODF 1.3.
- ActiveX controls disabled by default in Office LTSC 2024.
- Publisher removed.
- The Teams app isn’t preinstalled. It comes as a free separate download.
What 2021 already had
Many comparisons list features as new in 2024 that really shipped in Office 2021.
| Feature | Arrived with |
|---|---|
| XLOOKUP, XMATCH, LET | Excel 2021 |
| Dynamic arrays: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, RANDARRAY | Excel 2021 |
| Real-time co-authoring on OneDrive and SharePoint | The 2021 release |
| Dark mode in Word | The 2021 release |
| The Windows 11 style visual refresh | The 2021 release |
It matters for one simple reason. If XLOOKUP is why you’d upgrade, you already have it.
The honest reasons to move are LAMBDA, the text and array functions, the PowerPoint recording tools and session recovery.
Equally honest: the 2024 suite has no AI assistant. Copilot and the other fast-moving cloud features belong to Microsoft 365. No perpetual Office has them.
Coming from an even older version? Our Office 2019 vs 2024 comparison lists everything you gain in one jump.
Office 2021 vs 2024 editions and apps
The 2024 lineup has fewer editions.
| 2024 edition | What’s in it |
|---|---|
| Office Home 2024 | Word, Excel, PowerPoint, OneNote |
| Office Home & Business 2024 | The same plus Outlook and commercial use |
| Office LTSC Professional Plus 2024 | For businesses; adds Access |
The older lineup also had a retail Professional edition with Publisher and Access.
| Edition | Word, Excel, PowerPoint, OneNote | Outlook | Access | Publisher | Business use |
|---|---|---|---|---|---|
| Home & Student 2021 | Yes | No | No | No | No |
| Home 2024 | Yes | No | No | No | No |
| Home & Business 2021 | Yes | Yes | No | No | Yes |
| Home & Business 2024 | Yes | Yes | No | No | Yes |
| Professional 2021 | Yes | Yes | Yes | Yes | Yes |
| LTSC Professional Plus 2021 | Yes | Yes | Yes | Yes | Yes |
| LTSC Professional Plus 2024 | Yes | Yes | Yes | No | Yes |
Each consumer license covers one PC or one Mac. Access and Publisher have always been Windows only.
Professional Plus: 2021 and 2024
| Item | Detail |
|---|---|
| Office LTSC Professional Plus 2024 | Word, Excel, PowerPoint, Outlook, OneNote and Access, with Skype for Business as an optional component |
| Professional Plus 2021 | The same apps plus Publisher |
| Platform | Both are Windows only |
| Features | Both are locked to their launch feature set |
For offices, three practical differences stand out.
| Difference | What it calls for |
|---|---|
| Publisher files | A plan before you switch: keep one old PC for them, or convert them to Word or PDF |
| ActiveX controls | Disabled by default in 2024, so old forms and macros that use them need testing or a policy change |
| Access 2024 | Adds the Dataverse connector, useful if you’re moving data to Power Platform |
Deployment stays the same. The Office Deployment Tool and Configuration Manager work as they did for 2021. So do KMS and MAK activation.
Group Policy settings remain under the 16.0 registry keys.
Product details and licensing for the business edition are on our Office LTSC Professional Plus 2024 page.
Office 2021 vs 2024: speed
Microsoft’s only specific performance claim for the 2024 suite concerns Excel. Workbooks are faster and more stable when several of them calculate at the same time.
Beyond that, both versions share the same 16.0 code base and the same hardware requirements. On the same PC, daily speed in the other apps is similar.
Claims of exact percentage gains in startup time or memory use don’t come from Microsoft. We removed them from this article.
What usually makes Office feel faster is the 64-bit build on a PC with 8 GB of RAM or more and an SSD. You can do that with either version.
System requirements for Office 2021 and Office 2024
The Office 2024 hardware requirements are the same as for 2021.
| Requirement | Office 2021 | Office 2024 |
|---|---|---|
| Windows | Windows 11; LTSC also Windows 10 LTSC 2019/2021, Server 2019/2022/2025 | Windows 11; LTSC also Windows 10 LTSC 2019/2021, Server 2022/2025 |
| Processor | 1.1 GHz, 2 cores | 1.1 GHz, 2 cores |
| RAM | 4 GB | 4 GB |
| Disk space | 4 GB; 10 GB on Mac | 4 GB; 10 GB on Mac |
| Display | 1280 x 768 | 1280 x 768 |
| Arm PCs | Windows 11 minimum | Windows 11 minimum |
For Windows, Microsoft lists Windows 11 for both. Windows 10 home and office editions aren’t on the list.
A PC that will get the 2024 suite should normally get Windows 11 too.
On a Mac, the 2024 suite runs on the three most recent macOS versions.
Microsoft’s Office LTSC 2024 overview lists the systems for the business edition.
Office 2024 vs 2021: file compatibility
Yes, the files are compatible. Both versions use major version 16.0 and the same Open XML file formats.
A document saved in Word 2024 opens in Word 2021, and the other way round.
The only gaps are new features. A workbook built with LAMBDA, TEXTSPLIT or IMAGE shows errors in Excel 2021. Those functions don’t exist there.
Add-ins and templates built for 2021 generally work in 2024 with little testing. The registry paths stay the same. ActiveX-based tools are the main exception.
| Shared between both versions | Value |
|---|---|
| Major version | 16.0 |
| File formats | DOCX, XLSX, PPTX |
| Policy registry path | HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\16.0 |
Office 2021 vs 2024: licensing and updates
Licensing works the same way for both. With a consumer edition you pay once, put it on one PC or Mac and keep using it.
Both receive only security and quality updates, never new features.
Two practical notes.
First, there’s no discounted upgrade from 2021 to 2024. Microsoft sells the newer suite as a new license.
Second, perpetual Office doesn’t grow over time. Microsoft 365 subscribers get new features monthly.
That’s why Microsoft 365 vs Office 2024 is the next question many buyers ask.
For a fixed set of desktop apps on one computer, though, we’d call a one-time 2024 license the economical choice.
Office 2021 vs 2024 on the Mac
Office 2024 for Mac runs on the three most recent macOS versions, on Intel and Apple silicon.
| On the Mac | New in 2024 |
|---|---|
| Outlook | Scheduled send and Focused Inbox |
| Photos | Insert from an iPhone through Continuity Camera |
| Excel | LAMBDA, IMAGE and the new text and array functions |
| PowerPoint | Cameo and Recording Studio |
| Word | Session recovery |
| All apps | The new theme |
The rest mirrors Windows. Access and Publisher never existed on Mac, so nothing is lost there.
The two consumer editions each cover one Mac or one PC, your choice. Businesses can deploy Office LTSC Standard for Mac 2024 through volume licensing.
One practical point. Office for Mac tends to need a newer macOS each year, since it runs only on the three latest releases.
What the 2024 suite still lacks
- Copilot or other cloud AI features.
- OneDrive storage beyond the free allowance.
- New features after launch.
- Publisher.
- The preinstalled Teams app.
- Installs on several devices.
Those belong to Microsoft 365 subscriptions. For a fixed set of desktop apps on one computer, none of that is usually missed.
It helps to be clear-eyed here. Many buyers expect “the new Office” to bring AI writing help. It doesn’t.
What they get is a stable, patched set of apps. Years from now it will look and behave the same as on the day of setup.
For most home users and small offices, that predictability is the reason to buy perpetual Office in the first place.
Should you upgrade to Office 2024?
Yes, if the PC is online. The 2024 suite gives you a set of useful Excel and PowerPoint additions. For new purchases there’s no reason to choose 2021 today.
| Decision | Which PCs |
|---|---|
| Upgrade now | Home and office PCs that receive email, share files or use Outlook with a business mailbox |
| Upgrade after testing | PCs running ActiveX forms, old VBA macros, Publisher files or an Access front end |
| Keep 2021 for a while | An offline machine that runs one legacy task and never opens outside files |
The editions of the new suite are compared in Office 2024 Professional Plus vs Home and Business; all of them are under Office 2024.
How to upgrade from Office 2021
Perpetual versions don’t upgrade in place. Two Click-to-Run versions on one PC lead to activation and update conflicts.
Documents, Outlook data files and custom templates stay on the disk during the switch.
- Back up Outlook
.pstfiles and theNormal.dotmtemplate. Save the Excel personal macro workbook too. - Remove Office 2021 in Settings, Apps, Installed apps.
- Restart Windows.
- Redeem the Office 2024 key at
setup.office.comwith your Microsoft account. Then click Install on the account page. - Open Word and sign in with the same account. Check File, Account for “Product Activated”.
If removal fails, use one of the methods in our Office uninstall tool guide.
Pick 64-bit Office 2024 unless an old add-in needs 32-bit. Microsoft recommends 64-bit on devices with 4 GB of RAM or more.
Who gains from the upgrade
| You use Office for | Worth moving to 2024? |
|---|---|
| Letters, email, simple spreadsheets | Rarely; 2021 covers it |
| Heavy Excel work with formulas | Yes, for LAMBDA, TEXTSPLIT, VSTACK and dynamic charts |
| Recorded presentations | Yes, for Recording Studio and Cameo |
| Exchanging files with LibreOffice users | Some gain from ODF 1.4 |
| Publisher layouts | No; 2024 drops Publisher |
| AI features | Neither; Copilot needs Microsoft 365 |
For most desks the decision follows the first two rows. We keep 2021 where nobody writes complex formulas, and move the analysts first.
Quick answers
| Question | Short answer |
|---|---|
| Is Office 2024 worth it if you already have Office 2021? | Yes, for any PC that’s online. |
| Does Office 2024 include Copilot or other AI features? | No. |
| Did XLOOKUP and dynamic arrays come with Office 2021 or 2024? | With Office 2021. |
| Is Publisher included in Office 2024? | No. |
| Can you upgrade Office 2021 to Office 2024 for free? | No. |
| Can Office 2021 and Office 2024 open each other’s files? | Yes. |
| Will Office 2021 stop working? | No. |
Common mistakes with Office 2021 vs 2024
- Buying the new suite for XLOOKUP. The 2021 one already has it.
- Expecting Copilot. No perpetual Office includes it.
- Forgetting Publisher files. The new suite has no app for them.
- Putting the new version next to the old one. Remove 2021 first.
- Skipping the ActiveX test on office PCs. Old forms may stop working.
- Looking for a discounted upgrade. There isn’t one.
- Sending a LAMBDA workbook to a 2021 user. They’ll see errors.
Related guides
Terms used on this page
| Term | Meaning |
|---|---|
| Perpetual license | You pay once and keep that version |
| LTSC | Long-Term Servicing Channel, the volume license line for organizations |
| LAMBDA | A function for building your own reusable functions |
| Dynamic arrays | Formulas that spill results into many cells |
| Cameo | A live camera feed placed inside a slide |
| Session recovery | Word reopens the documents that were open before an unexpected close |
| ODF | OpenDocument Format |
| ActiveX | An older control technology used in some forms and macros |
| Click-to-Run | Microsoft’s streaming installer type |
FAQ
Is Office 2024 worth it if I already have Office 2021?
Yes, for any PC that's online. It adds new Excel functions and PowerPoint recording tools.
Does Office 2024 include Copilot or other AI features?
No. Copilot and the cloud AI features belong to Microsoft 365 subscriptions. Both perpetual versions keep a fixed feature set and get only security and quality updates.
Did XLOOKUP and dynamic arrays come with Office 2021 or 2024?
With Office 2021. Excel 2021 introduced XLOOKUP, XMATCH, LET and the dynamic array functions. Excel 2024 adds LAMBDA, IMAGE and 14 text and array functions.
Is Publisher included in Office 2024?
No. Publisher isn't part of any 2024 edition. The Professional and Professional Plus editions of 2021 still included it.
Can I upgrade Office 2021 to Office 2024 for free?
No. There's no free or discounted upgrade between perpetual versions. You remove the old suite and install the new one with its own key.
Can Office 2021 and Office 2024 open each other's files?
Yes. Both use the same DOCX, XLSX and PPTX formats and version 16.0. Only workbooks with functions new in Excel 2024 show errors in Excel 2021.
Will Office 2021 stop working?
No. The apps keep opening and saving files, the same as before.