Excel Error Codes

Fix Excel Stock Data Type Keeps Asking for Sign-In in Microsoft 365

Elise WilliamsElise Williams Nov 13, 2026 869 views

Question details

The user needs to stop Excel from repeatedly requesting sign-in when converting company names to the Stock data type, even though the user is already signed in and Microsoft 365 was recently reinstalled.

Fix Excel Stock Data Type Keeps Asking for Sign-In
Product
Microsoft 365 Excel
Device & OS
not provided
Scenario
Using Excel's linked Stock data type after reinstalling Microsoft 365, expecting the current signed-in account to authenticate the connected data service.
Observed behavior
Excel keeps asking for sign-in when a company name is converted to the Stock data type, despite already being signed in.
Before you start

Before you start, verify the Microsoft 365 account shown in Excel under File > Account, and make sure you have a stable internet connection because the Stock data type is an online connected service.

Solution 1Recommended

Confirm the Correct Microsoft 365 Account in Excel

Use this first when Excel repeatedly asks for sign-in after converting a company name to the Stock data type, because linked data types validate against the active Microsoft 365 account.

Excel Stock data type is a connected service, so it checks the account and license associated with the active Office session. If the wrong account or an expired session is active, Excel keeps prompting.

1
Open account settings

In Excel, click File > Account and look under User Information for the signed-in email address.

2
Sign out and restart Excel

Click Sign out, close Excel completely, then reopen the workbook.

3
Sign in with the licensed account

Click Sign in, enter the Microsoft 365 account that includes Excel desktop licensing, then retry Data > Stocks on a company name.

Confirm the Correct Microsoft 365 Account in Excel
Expected result: The Stock data type should stop asking for sign-in and display the stock card after the correct account is active.
Free Microsoft Office alternative

Use WPS Office as a Free Alternative When Excel Stock Data Type Keeps Asking for Sign-In

If Microsoft Excel's Stock data type sign-in loop blocks your spreadsheet work, WPS Office is a free, lightweight alternative that opens and edits Excel workbooks with familiar tools and .xlsx format compatibility without relying on Microsoft 365 linked-data authentication.

Avoid Excel Stock data type sign-in interruptions during spreadsheet workOpen, edit, and save Microsoft Excel .xlsx files with format compatibilityFree and lightweight Office suite with a familiar ribbon interfaceEasy migration for users coming from Microsoft 365 Excel
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel keep asking for sign-in when I use the Stock data type?

The Stock data type is a Microsoft 365 connected data service. Excel checks the active account's license and authentication token whenever you create or refresh a stocks link. If the account is missing, expired, or not licensed for Microsoft 365, Excel asks for sign-in again. Check File > Account to verify the active account.

How do I check which Microsoft 365 account is active in Excel?

Open Excel, click File > Account, and look under User Information. To switch accounts, click Sign out, restart Excel, and sign in with the Microsoft 365 account that has an active Excel license.

Will updating Office fix the Excel Stock data type sign-in prompt?

It can. Outdated Office builds sometimes have authentication or connected data type bugs. In Excel, go to File > Account > Update Options > Update Now, then restart Excel and test the Stock data type in a new workbook.

Does WPS Office support the same live Stock data type as Excel?

WPS Spreadsheets does not include Microsoft 365's linked Stock data service, so it will not fetch live stock data through that data type. You can still open and edit .xlsx files and use external data imports or manual stock values in WPS.

Can I still open an Excel workbook that contains stock data types in WPS Office?

Yes. WPS Office can open and edit the .xlsx workbook, but live linked stock data may appear as cached values or regular text. For live data, use an external data source or maintain the connected workbook in Microsoft Excel.