Excel Error Codes

Excel Stock Prices Will Not Update After Sign-In - Fix Microsoft 365 Stock Data Refresh Issues

Rana GarciaRana Garcia Nov 13, 2026 868 views

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.

Excel Stock Prices Will Not Update After Sign-In
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 you start

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.

Solution 1Recommended

Verify Your Microsoft 365 Account and Subscription in Excel

Use this first if Excel shows a subscription access message for stock data.

1
Open Excel and go to File > Account

In Excel, select File, then choose Account from the left menu.

2
Check the license and signed-in user

Under User Information and Product Information, confirm the displayed email matches the Microsoft 365 subscription that includes stock data types.

3
Sign out and sign back in if needed

Click Sign out, close Excel, reopen it, and sign in again with the correct Microsoft 365 account.

4
Refresh the stock data

Select the cells with stock data, go to Data > Refresh All, or right-click a stock cell and choose Data Type > Refresh.

Verify Your Microsoft 365 Account and Subscription in Excel
Data refreshed: If the data refreshes, Excel was using a different or stale account session.
Free Microsoft Office alternative

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. 1. Download WPS Office: Go to the official WPS Office website and click Download WPS Office Free.
  2. 2. Open the Excel file in WPS Spreadsheets: Launch WPS Office, click Open, and select the .xlsx workbook that contains stock data.
  3. 3. Edit and save the workbook: Make changes in WPS Spreadsheets, then save the file as .xlsx to keep Microsoft Excel compatibility.
Free to download and use for everyday spreadsheet editingOpens and saves .xlsx files with high compatibilityFamiliar ribbon interface for easy migration from Microsoft ExcelLightweight and works on Windows, macOS, Linux, iOS and AndroidNo Microsoft 365 subscription required for core workbook tasks
microsoft office alternative - wps office

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.