Excel Stock Prices Will Not Update After Sign-In - Fix Microsoft 365 Stock Data Refresh Issues
Question details
User needs Excel stock data types and prices to refresh after being prompted for subscription access despite being signed in with Microsoft 365.

- Product
- Microsoft Excel (Microsoft 365)
- Device & OS
- not provided
- Scenario
- User is signed in to Microsoft 365 but Excel stock prices no longer refresh and show a subscription access message.
- Observed behavior
- Excel requests an account with access to subscription services and does not update stock prices.
Before troubleshooting, make sure you are signed in to Excel with the Microsoft 365 account that includes stock data features, and confirm your internet connection is stable.
Verify Your Microsoft 365 Account and Subscription in Excel
Use this first if Excel shows a subscription access message for stock data.
In Excel, select File, then choose Account from the left menu.
Under User Information and Product Information, confirm the displayed email matches the Microsoft 365 subscription that includes stock data types.
Click Sign out, close Excel, reopen it, and sign in again with the correct Microsoft 365 account.
Select the cells with stock data, go to Data > Refresh All, or right-click a stock cell and choose Data Type > Refresh.

Update Office and Restart Excel
Use this when account verification does not resolve the refresh error.
Test the Workbook in Excel for the Web and Check Service Health
Use this to distinguish a local Office problem from a Microsoft stock data service issue.
Open Excel Workbooks Without Blocked Stock Data Features in WPS Office
WPS Office is a free, lightweight Microsoft Office alternative that opens .xlsx files with familiar tools and high format compatibility. It does not replace Microsoft's live stock data service, but it lets you continue viewing, editing, and sharing Excel workbooks without a Microsoft 365 subscription.
- 1. Download WPS Office: Go to the official WPS Office website and click Download WPS Office Free.
- 2. Open the Excel file in WPS Spreadsheets: Launch WPS Office, click Open, and select the .xlsx workbook that contains stock data.
- 3. Edit and save the workbook: Make changes in WPS Spreadsheets, then save the file as .xlsx to keep Microsoft Excel compatibility.

Frequently Asked Questions
Why does Excel show a subscription access message for stock data after sign-in?
This usually indicates a temporary Microsoft stock data service or authentication problem. Check File > Account in Excel to confirm the signed-in Microsoft 365 account, then sign out and back in.
How do I refresh stock data in Excel for the web?
Open the workbook at office.com in Excel for the web, select the stock cells, and use Data > Refresh All or right-click > Data Type > Refresh.
Will updating Office fix the stock price refresh issue?
It can help. In Excel go to File > Account > Update Options > Update Now, then restart Excel and refresh the data.
Does WPS Office support Excel stock data types?
WPS Office is a free Office alternative and opens .xlsx workbooks, but it does not provide Microsoft's live stock data service. You can still edit and save the workbook without a Microsoft 365 subscription.
What should I do if the issue affects multiple Excel workbooks?
If multiple workbooks fail, it is likely a Microsoft service-side issue. Test in Excel for the web, check the Microsoft 365 service health page, and monitor Microsoft Tech Community updates.




