'%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 Excel Stock Data Type Missing in Office for Mac 16.95
Question details
Users are unable to find or use the Stocks data type feature in Excel after installing the latest update.
- Product
- Microsoft Excel for Mac
- Device & OS
- Mac / macOS
- Scenario
- Attempting to access and use the Stocks data type in Excel after updating Microsoft 365 for Mac to version 16.95.
- Observed behavior
- The Stocks data type feature completely disappears from the Excel interface. Common troubleshooting steps such as license removal, re-signing in, and restarting the Mac do not restore the missing functionality.
Before proceeding, save all your open spreadsheets and completely close Microsoft Excel, as you will need to replace your current installation with a previous stable version.
Roll Back Office for Mac to Version 16.89
Since version 16.95 contains a bug that removes the Stocks data type, rolling back to version 16.89 or 16.89.1 is the most effective temporary workaround.
Standard troubleshooting methods like restarting your Mac, updating macOS, or removing your Office license will not fix this specific version bug. The only proven solution is to revert to a previous release where the feature is still intact.
Open the Applications folder on your Mac, locate the Microsoft Excel application, and drag it to the Trash to remove version 16.95.
Visit the official Microsoft Office for Mac update history webpage and download the installation package for version 16.89 or 16.89.1.
Run the downloaded installer package. Once the installation is complete, open Excel, go to the 'Help' menu in the top menu bar, select 'Check for Updates', and uncheck the option to automatically keep Microsoft apps up to date.
Try WPS Office for a Stable and Lightweight Spreadsheet Experience
If you are frustrated by unexpected missing features and bugs in Microsoft Office updates, consider switching to WPS Office. It offers a highly compatible, feature-rich, and stable environment for all your spreadsheet tasks on Mac without the heavy resource usage.
- 1. Download WPS Office for Mac: Visit the official WPS website and download the macOS installation package.
- 2. Install the Application: Open the downloaded file and drag the WPS Office icon into your Applications folder.
- 3. Open Your Excel Files Seamlessly: Launch WPS Office and directly open your existing Excel documents without needing to convert any file formats.
Frequently Asked Questions
Why did the Stocks data type disappear in Excel for Mac?
The disappearance is caused by a known software bug introduced in the Microsoft Office for Mac version 16.95 update, which prevents the Stocks data type from loading correctly in the interface.
Will signing out and reinstalling fix the missing Stocks feature?
No, users have confirmed that standard troubleshooting steps, such as removing the Office license, signing out, or restarting macOS, do not restore the feature in version 16.95. A version rollback is required.
How can I stop Mac Excel from automatically updating back to version 16.95?
After you install the older version (16.89), open Excel, click on 'Help' in the top Apple menu bar, select 'Check for Updates', and disable the automatic update setting in the Microsoft AutoUpdate tool.
When will Microsoft release a permanent fix for the missing Stock data type?
Microsoft has not yet provided a specific timeline for the fix. Users are advised to use version 16.89 temporarily and monitor the official Microsoft 365 release notes for upcoming patches that address this bug.
