Can You Disable the Excel Stock Data Disclaimer in Microsoft Excel?
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.
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.
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.
In Microsoft Excel, open the workbook that triggers the Stock data disclaimer.
When the dialog appears, read the notice so you understand that the workbook is connected to external stock data.
Select the Accept or OK button in the disclaimer dialog to continue. Excel will then load and refresh the Stocks data type.
Use the stock fields normally. The disclaimer may appear again when the workbook recalculates or reopens.

Remove Linked Stock Data Types to Stop the Disclaimer
Use this if you do not need live connected stock data and want the workbook to open without the data disclaimer.
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. Download WPS Office: Go to the official WPS Office website and click Download WPS Office Free.
- 2. Install and open WPS Office: Run the installer, then open WPS Office Spreadsheets from the home screen.
- 3. Open the Excel workbook: Click Menu > Open, select the .xlsx workbook, and inspect the spreadsheet in WPS Office.

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.




