Why Excel Beta Is Missing New Text and Dynamic Array Functions
Question details
The user is unable to find new text and dynamic array functions in their Excel Beta channel build.
- Product
- Microsoft Excel
- Device & OS
- Windows 11 Enterprise
- Scenario
- Trying to use new text and dynamic array functions after updating Excel to a Beta Channel build.
- Observed behavior
- The new functions do not appear in Excel despite being on the Beta Channel and running the latest updates, usually due to having a perpetual license like Office Professional Plus 2021 instead of a Microsoft 365 subscription.
Ensure your device is connected to the internet and save any open workbooks before checking your account settings or restarting Excel.
Verify Your Microsoft Office License Type
Check if you are using a Microsoft 365 subscription or a perpetual license (like Office 2021), as new dynamic array and text functions are exclusive to Microsoft 365.
Microsoft often releases new features to Beta channels, but many of these continuous feature updates are tied strictly to active Microsoft 365 subscriptions. Perpetual licenses, such as Office Professional Plus 2021, only receive security updates and do not get new functions even if enrolled in the Beta Channel.
Launch Microsoft Excel on your computer, create a blank workbook, and click on 'File' in the top-left corner of the ribbon.
Select 'Account' from the bottom-left navigation menu to open your account settings.
Look under the 'Product Information' section. Verify whether it says 'Subscription Product Microsoft 365' or lists a perpetual version like 'Office Professional Plus 2021'.
Update and Restart Excel for Microsoft 365 Subscribers
If you have an active Microsoft 365 subscription but still do not see the features, force an update and restart the application to trigger the rollout.
Try WPS Office for Advanced Spreadsheet Features
If your current Office license does not support the latest dynamic functions and upgrading to a Microsoft 365 subscription is too costly, consider switching to WPS Office. It provides a highly compatible, lightweight alternative with robust spreadsheet analysis tools at zero cost.
- 1. Download WPS Office: Visit the official WPS website and download the free WPS Office installer for your operating system.
- 2. Install and Open: Follow the simple installation prompts, then launch WPS Spreadsheets.
- 3. Load Your Excel Files: Click 'Open' and select your existing .xlsx files to continue working seamlessly with advanced functions.
Frequently Asked Questions
Which versions of Excel support dynamic array functions?
Core dynamic array functions were introduced in Microsoft 365 and Excel 2021. However, completely new dynamic array and text functions added after the 2021 release are exclusive to active Microsoft 365 subscribers.
Does joining the Office Insider Beta Channel give me free access to Microsoft 365 features?
No. Joining the Beta Channel only gives you early access to updates for the specific license you already own. It does not upgrade a perpetual license (like Office 2021) to a Microsoft 365 subscription.
How do I know if I am on the Beta Channel?
You can check your channel status by opening Excel, navigating to File > Account, and reviewing the 'About Excel' section, which will display your current build number and update channel name.
Will Office Professional Plus 2021 eventually get the new text and dynamic array functions?
Perpetual licenses like Office 2021 typically do not receive new feature updates after release. You would need to upgrade to the next perpetual release (such as Office 2024) or subscribe to Microsoft 365 to gain access to newly developed functions.
