'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Stop Excel Stock Data Types from Refreshing Automatically
Question details
The user wants to stop the automatic refresh of Stock data types in Microsoft Excel because the default refresh options are hard to locate.
- Product
- Microsoft Excel (Microsoft 365)
- Device & OS
- Windows 11
- Scenario
- Managing Stock data types refresh frequency in an Excel workbook.
- Observed behavior
- Stock data types refresh automatically, and the setting to change this to manual is not easily found in the standard data menus.
Ensure you have an active internet connection and that your Excel workbook contains at least one linked Stock data type cell before attempting to adjust these settings.
Change Data Type Refresh Settings to Manual
Modify the refresh behavior for Stock data types directly from the cell context menu so they only update when you manually choose to do so.
In Microsoft 365, Stock data types are designed to refresh automatically by default. To stop this, you need to access the specific Data Type settings pane via the right-click menu rather than the general Data ribbon.
Locate and click on any cell in your spreadsheet that currently contains a Stock data type.
Right-click the selected cell to open the context menu, then hover your cursor over the 'Data Type' option.
Click on 'Refresh Settings' from the expanded side menu. This action will open the Data Types Refresh Settings pane on the right side of your Excel window.
In the settings pane, select the 'Manual' option. This stops the automatic background updates and ensures the data only refreshes when you explicitly command it. This selection is saved automatically for the current workbook.
Manage Your Financial Spreadsheets with WPS Office
While Microsoft 365 offers proprietary Stock data types, WPS Office provides a highly compatible, lightweight, and completely free alternative for managing complex financial data, importing external datasets via CSV or web queries, and performing advanced calculations.
Frequently Asked Questions
Does the refresh setting apply to all Excel workbooks?
No, the Data Type refresh setting is saved specific to the current workbook. You will need to configure the refresh settings individually for different files.
Can I set the stock data to only refresh when opening the workbook?
Yes, in the Data Types Refresh Settings pane, you can select the 'Refresh on workbook open' option. This is a great middle-ground between manual and continuous automatic updates.
Why are my Excel stock data types not updating even on automatic?
This can happen if you lose your internet connection, or if Microsoft 365 is experiencing backend service issues. You can try manually clicking 'Refresh All' on the Data tab to force an update and check for error messages.
What versions of Excel support these Stock data types?
Linked Stock and Geography data types are premium features exclusively available to Microsoft 365 subscribers. They are not supported in older perpetual license versions like Excel 2016 or 2019.
