'%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)
Fix Excel Stocks Data Types Cannot Refresh in Microsoft 365
Question details
Users are unable to refresh Stocks data types in Excel and receive a prompt instructing them to sign in with an account associated with a subscription, despite already having an active Microsoft 365 plan.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Refreshing linked financial or stock market data inside an Excel spreadsheet.
- Observed behavior
- Excel blocks the data refresh and displays the error message 'Couldn't refresh data types', failing to recognize the user's active Microsoft 365 Family or Personal subscription.
Verify that your computer has a stable internet connection and confirm your Microsoft 365 subscription is currently active by logging into your Microsoft account online.
Re-authenticate Your Microsoft 365 Account and Update Excel
Refreshing premium data types requires a proper sync with Microsoft servers. Forcing a sign-out and sign-in cycle can resolve account recognition bugs.
Often, Excel encounters a temporary glitch where it fails to recognize a valid Microsoft 365 license. Manually refreshing your login credentials and installing the latest Office updates will usually restore access to Stocks data types.
Open Excel, navigate to File > Account, and click the Sign Out button under your user profile.
Close Excel and any other open Microsoft Office applications completely to clear the session cache.
Reopen Excel, go back to File > Account, and click Sign In. Enter the email address and password associated with your active Microsoft 365 subscription.
While still in the Account menu, click Update Options > Update Now to ensure you have the latest patches that might fix known data type bugs.
Check Microsoft Service Health
If re-authenticating does not work, the issue may be a temporary outage on Microsoft's data servers rather than an issue with your software.
Try WPS Office for Reliable and Fast Data Management
If temporary service outages and subscription errors in Microsoft 365 frequently disrupt your workflow, consider using WPS Office. It provides a free, lightweight, and fast-loading alternative with full format compatibility, a familiar user interface, and seamless migration for your daily spreadsheet tasks.
- 1. Download and Install WPS Office: Visit the official WPS Office website to download and install the free suite on your device.
- 2. Open your Excel files: Launch WPS Spreadsheet and open your existing .xlsx workbooks. Your layouts and formulas will remain intact.
- 3. Analyze your data seamlessly: Continue using pivot tables, advanced formulas, and built-in chart tools to track your financial data without interruption.
Frequently Asked Questions
Why does Excel say I need a subscription to use Stocks data types when I already have one?
Premium linked data types like Stocks and Geography are exclusive to Microsoft 365 subscribers. If you have an active subscription, Excel may be experiencing a temporary authentication glitch or failing to sync with Microsoft's servers. Signing out and back in usually resolves this.
Are Excel Stocks data types available in older versions like Office 2019 or 2016?
No. Linked data types, including Stocks, are only available to Microsoft 365 subscribers and users of Excel for the Web. Standalone perpetual licenses do not support this feature.
What should I do if refreshing stocks still fails after updating Excel?
If signing out, restarting, and updating does not fix the issue, it is highly likely that Microsoft's financial data provider is experiencing a temporary service outage. You should wait a few hours and try again, or check the Microsoft Service Health dashboard for updates.
