'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Missing Excel 2021 Features in Microsoft 365 and Excel 2016
Question details
The user is unable to access certain Excel 2021 features, such as map features or specific functions, while using Microsoft 365 or Excel 2016.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to use newer data visualization tools and functions that are available in Excel 2021 but do not appear in the current Excel installation.
- Observed behavior
- Specific functions and map features are missing from the Excel ribbon, and reinstalling the software does not restore them.
Before modifying your Office installation or changing update channels, ensure you have saved all open workbooks and have your Microsoft account login credentials handy.
Verify Your Microsoft 365 Subscription and Update Channel
Check if your current Microsoft 365 subscription is active and if your update channel restricts the release of new features.
Feature availability in Microsoft 365 relies heavily on your specific update channel (e.g., Current Channel vs. Semi-Annual Enterprise Channel). If you are on an enterprise channel, feature rollouts are delayed by several months to ensure stability.
Reinstalling Microsoft 365 will only fix broken installations, it will not bypass your subscription's channel limitations.
Launch Microsoft Excel. Click on 'File' in the top-left corner, then select 'Account' from the bottom left menu.
Under 'Product Information', verify that your Microsoft 365 Subscription Product says 'Active'.
Look under 'About Excel' to see your currently enrolled channel. If you are on a Semi-Annual channel, you may need to wait or ask your IT administrator to switch you to the Current Channel.
Manually Update Microsoft Office
Force an update to ensure your software downloads any pending feature releases available for your current license.
Try WPS Office for Free and Advanced Spreadsheet Features
Tired of dealing with confusing subscription channels, version limitations, and missing features? WPS Office is a free, lightweight Microsoft Office alternative that provides a familiar user interface and robust spreadsheet capabilities without complex licensing issues.
- 1. Download WPS Office: Visit the official WPS website and click 'Download WPS Office Free'.
- 2. Install the Software: Run the lightweight installer and follow the on-screen prompts to set up the software.
- 3. Open Your Workbooks: Launch WPS Spreadsheet and drag-and-drop your existing Excel files to continue working immediately.
Frequently Asked Questions
Will reinstalling Microsoft 365 add the missing Excel 2021 features?
No. Reinstalling Microsoft 365 resolves installation or corruption issues, but it will not grant you features that are excluded from your specific subscription plan or update channel.
Can I get Excel 2021 map features in Excel 2016?
No. Excel 2016 is a perpetual license (one-time purchase) and does not receive new feature updates. You must upgrade to Microsoft 365 or a newer perpetual license (like Excel 2021) to access newer data types and map charts.
How can I change my Microsoft 365 update channel to get features faster?
If you have a personal or family subscription, you can join the Office Insider program. If you are on an enterprise account, your IT administrator manages the update channel via the Microsoft 365 Admin Center or Office Deployment Tool.
