The main difference between Excel 2024 and Excel in Microsoft 365 is how they are updated. Excel 2024 is a one-time purchase frozen at its October 2024 feature set and patched for security until October 2029, while Excel 365 is a subscription that keeps receiving new functions, Copilot and Python in Excel. For most formula and charting work, the two behave the same.
| Feature | Excel 2024 | Excel in Microsoft 365 |
|---|---|---|
| Licence | One-time purchase | Subscription |
| New features after release | No, security and quality updates only | Yes, rolling updates |
| Dynamic arrays, XLOOKUP, LET, LAMBDA | Yes | Yes |
| TEXTSPLIT, VSTACK and the other 14 text and array functions | Yes | Yes |
| IMAGE function, dynamic charts from dynamic arrays | Yes | Yes |
| GROUPBY and other newer functions | No | Yes |
| Python in Excel | No | Yes, on qualifying plans |
| Copilot in Excel | No | Yes, on plans that include it |
| Real-time co-authoring | Not part of the LTSC feature set | Yes, with OneDrive or SharePoint |
| Support ends | 9 October 2029 | Ongoing while subscribed |
What is the difference between Excel 2024 and Excel 365?
Excel 2024 is the perpetual version of Excel sold in Office 2024, with a fixed set of features that will not grow, while Excel in Microsoft 365 is the same core application delivered through a subscription and updated continuously, so it gains new functions, AI features and cloud capabilities that Excel 2024 never receives.
Both open the same .xlsx files and share the same interface, ribbon and calculation engine. Someone moving between them for everyday spreadsheets will rarely notice which one they are using.
The gap shows up at the edges: recently released functions, Python, Copilot and live collaboration. Microsoft's Office LTSC 2024 overview describes the perpetual release as lacking "the latest cloud-backed features", naming real-time collaboration and AI-driven automation.
What's new in Excel 2024?
Excel 2024 adds dynamic charts that work with dynamic arrays, 14 new text and array functions, the IMAGE function, the LAMBDA function, faster workbook performance, improved accessibility, support for OpenDocument Format 1.4 and XLL add-ins blocked by default, according to Microsoft's What's new in Excel 2024 article.
- Text functions: TEXTBEFORE, TEXTAFTER and TEXTSPLIT.
- Array functions: VSTACK, HSTACK, TOROW, TOCOL, WRAPROWS, WRAPCOLS, TAKE, DROP, CHOOSEROWS, CHOOSECOLS and EXPAND.
- IMAGE: places a picture from a web address inside a cell.
- LAMBDA: builds reusable custom functions without VBA.
Microsoft also removed Publish to Power BI from Excel 2024 and points users to the Power BI service instead. If you are coming from Excel 2021, our comparison of Office 2024 vs Office 2021 covers the wider changes.

Which Excel functions are only in Microsoft 365?
Functions Microsoft released after Excel 2024's feature set was fixed are only in Excel for Microsoft 365; GROUPBY is a clear example, because Microsoft's GROUPBY function page lists it as applying to Excel for Microsoft 365 only, so a workbook that uses it will not calculate correctly when opened in Excel 2024.
The safest way to check a specific function is its Microsoft support page. If the "Applies to" line names Excel 2024, it works in both; if it names only Excel for Microsoft 365, it is subscription-only.
Cause and effect: a formula that uses a subscription-only function shows a #NAME? error in Excel 2024. In a shared office where some people use Microsoft 365 and others Excel 2024, one person's new formula can break a colleague's report without anyone changing the data.
Does Excel 2024 have Python in Excel?
No, Python in Excel is not available in Excel 2024: Microsoft's Python in Excel availability page says free and perpetual consumer licences do not support it and that a paid Microsoft 365 licence is required, with full availability on business and enterprise plans and preview access on Personal and Family plans.
Python in Excel runs calculations in Microsoft's cloud, which is why it is tied to a subscription. Qualifying plans include a limited monthly allowance of premium compute, and businesses can buy an add-on for more.
If you already use Python locally, Excel 2024 still opens files you generate with Python libraries such as pandas. You simply cannot write Python inside a cell.
Does Excel 2024 include Copilot?
No, Excel 2024 does not include Copilot, because Copilot features are delivered through Microsoft 365 subscriptions that connect to Microsoft's cloud AI services, while the one-time Office 2024 release receives no new features after launch, so its analysis tools stay exactly as they were at launch.
Excel 2024 still has the non-AI analysis tools many users rely on: PivotTables, Power Query, Power Pivot in the editions that include it, Goal Seek and the Solver add-in.
Our guide to whether Office 2024 includes Copilot explains which Microsoft 365 plans add it and what it does in each app.
Can Excel 2024 and Excel 365 open the same files?
Yes, Excel 2024 and Excel 365 both use the .xlsx, .xlsm and .xlsb formats, so they open each other's workbooks without conversion; the only problems arise when a workbook relies on a feature or function that exists in Microsoft 365 but not in Excel 2024, which then shows as an error or an unsupported item.
For mixed teams, agree on a lowest common denominator. If anyone uses Excel 2024, keep shared templates to functions listed for Excel 2024, and test important workbooks on both versions before rolling them out.
What we commonly see: finance teams adopting GROUPBY or Python formulas in Microsoft 365, then emailing the file to an external accountant on a perpetual version. Pasting values into a copy before sending avoids the problem.
Is Excel 2024 or Excel 365 better value?
Excel 2024 is usually better value if you work alone, want a fixed cost and do not need Copilot, Python or new functions, while Excel in Microsoft 365 is better value if you share workbooks live with colleagues, want 1 TB of OneDrive storage or rely on the newest features, because those benefits come only with the subscription.
At the time of writing (November 2026), Microsoft's US list price for Microsoft 365 Personal is $99.99 a year, which includes Excel alongside the other apps. A one-time Office 2024 licence is paid once and covers about three more years of security updates from today.
Our five-year cost comparison of Office 2024 and Microsoft 365 sets out the totals. Note that Excel is not commonly sold as a cheaper stand-alone perpetual app; most buyers get it as part of an Office suite.
How long will Excel 2024 be supported?
Excel 2024 is supported until 9 October 2029 as part of Office 2024, which means it receives security fixes and quality updates until then but no new features; after that date it keeps working, though unpatched, whereas Excel in Microsoft 365 stays supported for as long as you keep the subscription and the app up to date.
Office LTSC 2024, the volume edition, follows the Fixed Lifecycle Policy with five years of mainstream support and no extended support, which lands in the same autumn. Either way, a purchase in November 2026 buys roughly three years of supported use.
Planning around that date matters for businesses with audit or insurance requirements. Our article on how long Office 2024 will be supported covers what happens at the end date and the realistic replacement options.
Which Office 2024 edition includes Excel 2024?
Every Office 2024 edition includes Excel 2024: Office Home 2024, Office Home & Business 2024, Office Professional Plus 2024 and Office LTSC Standard and Professional Plus 2024 all ship the same Excel desktop app, so choose the edition based on whether you also need Outlook, Access or commercial-use rights.
For a Windows PC used for analysis and reporting, Office 2024 Professional Plus for Windows adds Access for databases that outgrow a spreadsheet; see the current price on the product page. Our article on Microsoft Access 2024 in Office Pro Plus explains when that matters.
Advanced nuance: Power Pivot and some data-model features have historically varied by edition. If your workbooks depend on them, check the edition-specific feature list before buying rather than assuming every Excel 2024 is identical in that respect.
Frequently asked questions
Is Excel 2024 the same as Excel 365?
Not quite. They share the same interface, file formats and most functions, but Excel 2024 is a fixed release that gets only security and quality updates, while Excel in Microsoft 365 keeps receiving new functions and features. A workbook built with the newest Microsoft 365 functions may not calculate correctly in Excel 2024.
Does Excel 2024 have XLOOKUP?
Yes. XLOOKUP, XMATCH, LET, FILTER, SORT, UNIQUE and the other dynamic array functions introduced over recent years are all in Excel 2024. Excel 2024 also adds LAMBDA and 14 text and array functions such as TEXTSPLIT, VSTACK and CHOOSECOLS that were not in Excel 2021.
Will Excel 2024 get new functions through updates?
No. Excel 2024 receives security fixes and quality updates until 9 October 2029, but Microsoft does not add new functions or features to perpetual releases. New functions appear first in Excel for Microsoft 365 and may reach a future one-time version, if Microsoft releases one.
Can I buy Excel 2024 on its own?
Microsoft has offered stand-alone perpetual Excel in some versions and markets, but most buyers get Excel 2024 as part of an Office 2024 suite, which usually costs little more and adds Word, PowerPoint and other apps. Check availability in your region before assuming a stand-alone version exists.
Does Excel 2024 work on a Mac?
Yes. Excel 2024 is included in Office Home 2024 and Office Home & Business 2024 for Mac, and Microsoft's What's new in Excel 2024 article covers both Windows and Mac. Office Professional Plus 2024 is Windows-only, so Mac users choose one of the Home editions instead.
Related guides
- Office 2024 vs Office 2021
- Office 365 "lifetime" licences explained
- Microsoft Office versions compared
- Does Office 2024 include Copilot?
Links in this guide
| Link | Type | Why it helps |
|---|---|---|
| Microsoft Learn: Office LTSC 2024 overview | External | States which cloud features the perpetual release lacks |
| Microsoft: What's new in Excel 2024 | External | Official list of Excel 2024 features |
| Office 2024 vs Office 2021 | Internal | Upgrade view for Excel 2021 users |
| Microsoft: GROUPBY function | External | Example of a Microsoft 365-only function |
| Microsoft: Python in Excel availability | External | Confirms perpetual licences lack Python |
| Does Office 2024 include Copilot? | Internal | Copilot availability by plan |
| Office 2024 vs Microsoft 365 cost | Internal | Five-year cost totals |
| Office 2024 end of support | Internal | What changes after October 2029 |
| Office 2024 Professional Plus for Windows | Internal | Excel 2024 plus Access on Windows |
| Microsoft Access 2024 in Pro Plus | Internal | When Access is worth having |
