Data Import & Export

How to Fix Excel Stocks and Currency Data Types Disappeared in Office 2024

Chanuka Geekiyanage Sep 27, 2026 869 views

Question details

The user needs a stable way to retrieve financial data because the built-in Stocks and Currency data types keep disappearing in Office Home 2024.

Fix: Excel Stocks and Currency Data Types Disappeared in Office 2024

Product: Microsoft Excel 2024
Device & OS: not provided
Scenario: Attempting to track and update financial information using connected data types in Excel.
Observed behavior: The Stocks and Currency data types disappear intermittently, especially after using compatibility mode. The StockHistory feature reports as blocked, and standard troubleshooting like reinstalling or changing architecture bits does not provide a permanent fix.

Before you start

Ensure you have an active, stable internet connection and identify a reliable financial website URL to pull stock or currency data before setting up a web query.

Solution 1Recommended

Import Data Manually Using IQY (Web Query) Files

Bypass the blocked connected data types feature by manually creating and importing an Internet Query (IQY) file to fetch stock data.

Since the native data types functionality is intermittently blocked in Office 2024, relying on legacy external data imports ensures you can still retrieve the necessary financial information.

Create an IQY File

Open a plain text editor like Notepad. Type or paste the URL of the finance page containing your required stock or currency table, and save the file with an '.iqy' extension (e.g., stocks.iqy).

Access External Data Import

Open your Excel spreadsheet, navigate to the 'Data' tab on the top ribbon, and click on 'Import External Data' (or 'Get Data' > 'From File' depending on your exact ribbon layout).

Load the Query

Browse your computer for the .iqy file you just created, select it, and choose the cell where you want the imported data table to start.

Refresh Data

To update your stock and currency figures in the future, simply navigate to the 'Data' tab and click 'Refresh All'.

Import Data Manually Using IQY (Web Query) Files

Solution 2

Use the 'New Web Query' Feature

Utilize the modern Web Query tool to scrape and import financial data directly from websites without creating local files.

Free Microsoft Office alternative

Try WPS Office for Reliable Spreadsheet Management

If persistent bugs and blocked features in Microsoft Office are disrupting your workflow, consider switching to WPS Office. It provides a lightweight, free, and stable environment for managing complex spreadsheets and data tasks.

1. Download and Install: Visit the official WPS website to download and install WPS Office for free on your device.
2. Open Your Spreadsheet: Launch WPS Spreadsheets and open your existing .xlsx files directly. All your data and standard formatting will remain intact.
3. Continue Working Seamlessly: Use the familiar ribbon interface to analyze your data, apply formulas, and manage your financial records securely.

Highly compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Free and lightweight, avoiding heavy architecture conflicts and bugs.Familiar user interface allowing for seamless migration with zero learning curve.Robust data management tools without intermittent feature blocking.

microsoft office alternative - wps office

Frequently Asked Questions

Why did my Excel Stocks and Currency data types disappear?

This intermittent issue in Office 2024 is often triggered after saving or opening files in older compatibility modes, which causes the connected data types feature to glitch or become permanently blocked by the software architecture.

Will reinstalling Office 2024 restore the missing data types?

According to user reports, standard troubleshooting steps—such as repairing Office, switching between 32-bit and 64-bit versions, or completely reinstalling the software—rarely provide a permanent fix for this specific bug.

What are IQY files and how do they replace data types?

IQY (Internet Query) files are simple text files used by Excel to download and import data from a specific web page URL. They serve as a highly reliable alternative for fetching financial data when native connected data types fail.

Excel & Data Problems