Data Import & Export

Fix Excel Stocks Data Type Not Showing Price Fields on Mac

Maira Mehtab Sep 22, 2026 869 views

Question details

The user is unable to view essential financial fields such as stock prices and 52-week highs when using the Stocks data type in Excel.

Product: Excel for Mac
Device & OS: macOS
Scenario: Attempting to retrieve financial data using Excel's connected data types while traveling or operating in a different geographic region.
Observed behavior: The Stocks data type fails to display specific financial fields, leaving price and other metrics blank or unavailable.

Before you start

Ensure your Mac has an active internet connection, as linked data types require online access to fetch real-time financial information from Microsoft's data providers.

Solution 1Recommended

Verify Region Settings, Subscription License, and Software Version

Connected data types like Stocks rely heavily on specific Microsoft 365 subscriptions, supported regional settings, and up-to-date software. Traveling to a different region can cause data providers to block certain fields.

Financial data providers often restrict access to real-time or delayed stock data based on your current IP address and macOS region settings. If you are normally based in the US but visiting another country, the data provider may temporarily withhold price fields.

Check Your Microsoft 365 License

Open Excel for Mac, click on 'Excel' in the top Apple menu bar, and select 'About Microsoft Excel'. Verify that your license is listed as Microsoft 365 (e.g., Family or Personal), as standalone offline versions do not support connected data types.

Verify macOS Language & Region Settings

Click the Apple logo in the top-left corner of your screen and go to 'System Settings'. Select 'General', then click 'Language & Region'. Ensure your region matches your subscription's home country.

Update Excel for Mac

In Excel, click on 'Help' in the top menu bar and select 'Check for Updates'. Install the latest version available to ensure full compatibility and bug fixes for linked data types.

Regional Travel Impact: If you are currently traveling abroad, you may need to use a VPN routed to your home country to regain access to specific stock market fields provided by regional data partners.

Solution 2

Review Microsoft Financial Data Sources

Checking the official data source lists helps confirm if your desired stock exchange or data field is currently supported by Microsoft's backend providers.

Free Microsoft Office alternative

Switch to WPS Office for a Seamless Spreadsheet Experience

If regional restrictions and connected data type errors in Microsoft Excel are slowing down your financial tracking, consider trying WPS Office. It provides a lightweight, highly compatible alternative for managing your financial spreadsheets without the heavy subscription fees.

1. Download and Install WPS Office: Visit the official WPS Office website, download the Mac version, and follow the on-screen instructions to install it on your device.
2. Open Your Excel File: Launch WPS Spreadsheets, click on 'Open' from the home screen, and select your existing .xlsx financial tracking file.
3. Manage Your Financial Data: Use built-in charts, pivot tables, and standard formulas to track and analyze your financial data without relying on restrictive regional connections.

Highly compatible with Microsoft Excel (.xlsx, .xls) and CSV formats.Free to use with comprehensive data analysis and calculation tools.Lightweight installation and smooth performance on Mac, Windows, and mobile devices.No strict regional blocks preventing basic offline spreadsheet functionalities.

microsoft office alternative - wps office

Frequently Asked Questions

Why did my Excel Stocks data type suddenly stop showing prices?

This usually happens if you travel to a different country where the underlying data provider has regional restrictions, or if your Microsoft 365 subscription syncing encounters an error.

Do I need a specific license to use the Stocks data type in Excel?

Yes, the Stocks and Geography linked data types require an active Microsoft 365 subscription (such as Personal, Family, or Enterprise). They are not supported in perpetual standalone versions like Office 2019 or 2021.

Can I manually refresh the stock data if the fields are blank?

Yes. Navigate to the 'Data' tab on the Excel ribbon and click the 'Refresh All' button to force the application to fetch the latest available data from the provider.

Excel & Data Problems