'%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)
How to Fix Missing Excel Data Types in Microsoft 365 Beta Builds
Question details
Users operating on Microsoft 365 Beta and Insider builds (such as release 2501) noticed that Excel Data Types were temporarily unavailable or missing.
- Product
- Microsoft Excel 365
- Device & OS
- not provided
- Scenario
- Using Beta or Insider preview builds to test new Microsoft Excel features and discovering standard data type functionalities are absent.
- Observed behavior
- Excel Data Types are missing or unavailable in earlier preview builds, but have been confirmed as restored by Microsoft in version 2502.
Verify your current Microsoft 365 subscription channel and check which Excel build version you have installed by navigating to File > Account.
Update to Excel Version 2502 or Later
Updating your Microsoft 365 Insider build to version 2502 resolves the issue and restores the missing Data Types.
Microsoft confirmed that Data Types were restored in Excel version 2502. If you are on an earlier build like 2501, you must force a manual update to retrieve these missing features.
Launch Excel and click on 'File' in the top-left corner, then select 'Account' from the bottom-left menu pane.
Under the 'Product Information' section, click on 'Update Options' located next to the Office Updates heading.
Select 'Update Now' from the drop-down menu to download and install version 2502 or a newer build where the Data Types feature is fully restored.
Submit Feedback for Missing Insider Features
If a feature remains missing in a preview build, reporting it directly to Microsoft ensures they can address the issue before a general release.
Use WPS Office for a Stable, Bug-Free Spreadsheet Experience
Tired of missing features in experimental updates? WPS Office offers a highly stable, lightweight, and free alternative to Microsoft Office with seamless compatibility for all your Excel files.
- 1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite for your operating system.
- 2. Install the software: Run the setup file and follow the on-screen instructions to complete the installation in seconds.
- 3. Open your Excel files: Launch WPS Spreadsheets and open your existing .xlsx files directly with zero formatting loss.
Frequently Asked Questions
Why do features disappear in Microsoft 365 Insider builds?
Insider and Beta builds are active testing environments. Microsoft may temporarily remove or alter features to fix underlying bugs or make background improvements before rolling them out to the general public.
How do I know which version of Excel I am currently using?
Open Excel, click on 'File', and select 'Account'. Your current version, build number, and update channel will be clearly displayed under the 'About Excel' section.
Are Excel Data Types available in the standard release channel?
Yes, standard release channels maintain stable features like Excel Data Types. The temporary removal and restoration only affected specific preview builds, such as Insider version 2501.
