How to Fix Excel for Mac Stock Data Tab Not Working
Question details
The Stocks data feature in Excel for Mac is unresponsive or grayed out when working on specific workbooks.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- A user is trying to use the Stocks data type feature to pull real-time financial data into their spreadsheet but finds the button disabled.
- Observed behavior
- The Stocks data tab cannot be clicked or activated because the workbook is saved in an older file format.
Ensure you have an active internet connection and that you are signed in with a valid Microsoft 365 subscription, as the Stocks data type requires both to function properly.
Save the Workbook in the .xlsx Format
Converting your legacy .xls workbook to the modern .xlsx format enables newer Excel features like Stocks.
The Stocks data type is a modern Microsoft 365 feature that relies on cloud connectivity. Because the older .xls file format (Excel 97-2004) does not support these modern dynamic arrays and connected data types, Excel automatically disables the feature to prevent data corruption.
With your problematic workbook open in Excel, click on 'File' in the top Apple menu bar and select 'Save As'.
In the save dialog box, locate the 'File Format' dropdown menu and change it from 'Excel 97-2004 Workbook (.xls)' to 'Excel Workbook (.xlsx)'.
Click 'Save'. Close the current document and reopen the newly created .xlsx file. The Stocks tab will now be responsive and ready to use.

Update Excel to a Supported Version
Check for updates to ensure your Excel application is fully compatible with connected data features.
Try WPS Office for Seamless Spreadsheet Management
If you frequently encounter compatibility issues with legacy formats or want to avoid hefty Microsoft 365 subscription fees, WPS Office is an excellent, free alternative. It offers a lightweight, highly compatible spreadsheet solution with a familiar interface to help you manage your financial data effortlessly.
- 1. Download the software: Visit the official WPS Office website and download the free installation package for your Mac.
- 2. Open your files instantly: Launch WPS Spreadsheet and drag-and-drop your existing .xls or .xlsx workbooks directly into the application.
- 3. Analyze your data: Use the rich set of built-in formulas and formatting tools to handle your financial tracking seamlessly.

Frequently Asked Questions
Why is the Stocks data type missing completely from my Excel ribbon?
The Stocks data type is exclusively available to Microsoft 365 subscribers. If you are using a perpetual license like Office 2019 or Office 2021 for Mac, or if you are not signed in, this feature will be hidden.
Do I need an internet connection to use the Stocks feature?
Yes. Because the feature pulls real-time financial data, company profiles, and stock prices from online servers, an active internet connection is required to fetch or refresh the data.
What happens to my Stocks data if I save the file back to an .xls format?
If you save a workbook containing Stocks data types as a legacy .xls file, the dynamic connection will be broken. The cells will retain their last known text or numerical values, but they will no longer update automatically or show rich data cards.




