Office Settings & Configuration

Can You Disable the Excel Stock Data Disclaimer in Microsoft Excel?

Anum MushtaqAnum Mushtaq Nov 13, 2026 869 views

Question details

The user wants to know whether the disclaimer that appears when opening a workbook with the Excel Stocks data type and connected data features can be disabled.

Product
Microsoft Excel
Device & OS
not provided
Scenario
A user opens a workbook that uses the Excel Stocks data type and connected data features, and Excel shows a data disclaimer.
Observed behavior
The disclaimer appears because the workbook uses connected Stock data; Microsoft Excel does not provide a workbook setting to disable it.
Before you start

Check which cells in your workbook use the Stocks data type before making changes. If you only need static values, identify those connected data cells so you can convert or remove them.

Solution 1Recommended

Accept the Stock Data Disclaimer and Continue Using the Workbook

Use this if you need the live Stocks data type and can accept Microsoft Excel's connected data notice.

The disclaimer is part of how Excel's Stocks data type and connected data features work, not a broken workbook setting. Microsoft does not provide a supported global toggle to turn it off.

1
Open the affected workbook

In Microsoft Excel, open the workbook that triggers the Stock data disclaimer.

2
Review the connected data notice

When the dialog appears, read the notice so you understand that the workbook is connected to external stock data.

3
Click Accept or OK

Select the Accept or OK button in the disclaimer dialog to continue. Excel will then load and refresh the Stocks data type.

4
Resume working with the workbook

Use the stock fields normally. The disclaimer may appear again when the workbook recalculates or reopens.

Accept the Stock Data Disclaimer and Continue Using the Workbook
Stock data remains active: The Stock data type continues to update after you accept the notice.
Free Microsoft Office alternative

Use WPS Office as a Free Alternative for Excel Workbooks with Stock Data Notices

WPS Office is a free, lightweight Microsoft Office alternative that opens .xlsx workbooks with familiar formatting and strong compatibility. While Microsoft controls the Excel Stock data disclaimer, WPS Office gives you an easy way to view and edit Excel files without a Microsoft 365 subscription.

  1. 1. Download WPS Office: Go to the official WPS Office website and click Download WPS Office Free.
  2. 2. Install and open WPS Office: Run the installer, then open WPS Office Spreadsheets from the home screen.
  3. 3. Open the Excel workbook: Click Menu > Open, select the .xlsx workbook, and inspect the spreadsheet in WPS Office.
Opens and edits Excel .xlsx workbooks with strong Microsoft Office format compatibility.Free, lightweight suite with a familiar spreadsheet UI for easy migration from Microsoft Excel.Lets you review Excel workbooks that contain Microsoft Stock data type notices without paying for Microsoft Office.Seamlessly preserves common formulas, formatting, and data layouts when moving between Excel and WPS Office.
QA img-9

Frequently Asked Questions

Can the Excel Stock data disclaimer be permanently disabled?

No. Microsoft Excel does not provide a workbook-level or global setting to turn off the Stock data type disclaimer. You can accept it each time or convert/remove the linked Stock data cells.

Does WPS Office show the same Stock data disclaimer when opening an Excel workbook?

WPS Office can open Excel .xlsx files, but the live Stock data type connected feature is a Microsoft Excel service. If a workbook contains those linked data types, WPS Office may show a compatibility notice or may not refresh the live stock data; open the file in WPS Office Spreadsheets to inspect the content.

How do I find which cells use the Stock data type before removing it?

In Excel, select a cell and check the Data tab > Data Types group. Cells with the Stock data type usually show a stock or building icon, and you can review linked data types in the Queries & Connections pane.

Will converting Stock data to text remove the disclaimer without losing current values?

Yes. If you convert the linked Stock data cells to static text or paste values, the workbook no longer contains connected Stock data, so the disclaimer should stop appearing. However, stock prices and fields will no longer update automatically.