Office for Mac Issues

How to Fix Excel for Mac Stock Data Tab Not Working

Chanuka GeekiyanageChanuka Geekiyanage Oct 23, 2026 869 views

Question details

The Stocks data feature in Excel for Mac is unresponsive or grayed out when working on specific workbooks.

How to Fix Excel for Mac Stock Data Tab Not Working
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the Save As dialog

With your problematic workbook open in Excel, click on 'File' in the top Apple menu bar and select 'Save As'.

2
Change the file format

In the save dialog box, locate the 'File Format' dropdown menu and change it from 'Excel 97-2004 Workbook (.xls)' to 'Excel Workbook (.xlsx)'.

3
Save and reopen

Click 'Save'. Close the current document and reopen the newly created .xlsx file. The Stocks tab will now be responsive and ready to use.

Save the Workbook in the .xlsx Format
Verify Functionality: Once reopened, select a cell with a company name, and click the 'Stocks' button in the Data tab to confirm it converts the text into a rich data type.
Free Microsoft Office alternative

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. 1. Download the software: Visit the official WPS Office website and download the free installation package for your Mac.
  2. 2. Open your files instantly: Launch WPS Spreadsheet and drag-and-drop your existing .xls or .xlsx workbooks directly into the application.
  3. 3. Analyze your data: Use the rich set of built-in formulas and formatting tools to handle your financial tracking seamlessly.
Fully compatible with Microsoft Excel formats, including both .xls and .xlsx.Free and lightweight, avoiding heavy subscription costs.Familiar, tabbed user interface for a zero-learning-curve transition.Comprehensive built-in financial and statistical formulas for robust data analysis.
microsoft office alternative - wps office

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.