Fix Excel Stocks Data Type Not Refreshing or Requiring Sign-In
Question details
The user needs to resolve Excel Stocks data type refresh failures or repeated sign-in prompts caused by account authentication, Microsoft 365 licensing, connected experiences, service availability, or workbook data problems.
- Product
- Microsoft Excel / Microsoft 365
- Device & OS
- not provided
- Scenario
- The user relies on the Excel Stocks data type for stock and financial data and needs it to continue refreshing after a sign-in or licensing problem.
- Observed behavior
- The Stocks data type stops refreshing, asks for sign-in, or remains broken after reinstalling Microsoft 365 even when the account is licensed.
Before troubleshooting, sign in with the Microsoft 365 account that holds the active Excel license and confirm the Stocks data type still appears under the Data tab.
Verify Microsoft 365 sign-in and enable connected experiences
Use this first when Excel shows a sign-in prompt or the Stocks data type does not update, because the data connection requires an authenticated Microsoft 365 account.
Stocks data is provided through Microsoft connected services. If connected experiences are turned off, the Data tab may show the Stocks option but refreshes can fail silently or prompt repeatedly.
In Excel, select File > Account, and check that the displayed account is the licensed Microsoft 365 account.
Go to File > Options > Trust Center > Trust Center Settings > Privacy Options, then make sure Enable connected experiences is selected.
Return to File > Account, sign out, restart Excel, and sign in again to refresh the authentication token.
Test the Stocks data type in a new workbook and check Microsoft 365 service health
Use this when the account and privacy settings are correct but the existing workbook still fails, to separate workbook damage from a server-side outage.
Export or recover stock data from an unstable workbook
Use this if a workbook stops opening or stock data may be lost; it preserves the current data while you continue troubleshooting.
Use WPS Office to Open and Edit Excel Workbooks Without Microsoft 365 Stock Data Sign-In Issues
If Excel Stocks data type sign-in and refresh problems keep blocking your work, WPS Office is a free, lightweight Microsoft Office alternative that opens .xlsx files, keeps familiar spreadsheet tools, and lets you edit and save workbooks without the same connected-service dependency.
- 1. Download WPS Office: Go to the WPS Office download page and get the free Windows or Mac installer.
- 2. Open an existing Excel workbook: Launch WPS Office, select Open, and choose the .xlsx workbook you need to edit or recover.
- 3. Continue working in familiar spreadsheet tools: Use the WPS spreadsheet ribbon and functions to edit, calculate, and save the workbook in Excel-compatible format.
Frequently Asked Questions
Why does Excel Stocks data type keep asking me to sign in even though I am signed in?
It often means connected experiences are disabled or the stored sign-in token is stale. In Excel, select File > Account, sign out, restart Excel, sign in again, and check File > Options > Trust Center > Trust Center Settings > Privacy Options to enable connected experiences.
Will reinstalling Microsoft 365 fix the Stocks data type refresh problem?
Not always. Reinstalling fixes local installation files, but Stocks refresh failures are frequently caused by account licensing, connected experiences, Microsoft service outages, or workbook connection issues. Test in a new blank workbook and check Microsoft 365 service health before reinstalling.
Can I still open my workbook if Excel Stocks data type makes it unstable?
Yes. Copy the file first, then in Excel use File > Open > Browse, click the file, select the Open dropdown, and choose Open and Repair. If it opens, copy critical stock data to another sheet with Paste Values.
Is there a free alternative if Excel data types keep failing?
WPS Office is a free Microsoft Office alternative that opens and saves .xlsx files with familiar spreadsheet tools, so you can continue working on ordinary workbook tasks without relying on Excel Stocks data type connected services.
