'%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)
How to Fix Excel Sign-In Errors When Refreshing Stock Data
Question details
Users encounter a sign-in error prompting for a subscription account when trying to refresh stock data types in Excel.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Refreshing stock or geographic data types in Excel.
- Observed behavior
- Excel displays a message stating that the user must sign in with a subscription account to refresh data, even if they are already signed in with an active Microsoft 365 account.
Ensure your computer has a stable internet connection and verify that your Microsoft 365 subscription is currently active by logging into your Microsoft account online.
Verify Your Subscription Account and Microsoft Service Health
Confirm you are signed in with the correct account and check if Microsoft is experiencing a known service outage affecting data types.
In many cases, this error is caused by a sudden Microsoft service disruption or an authentication glitch within the Excel application. Refreshing your login token or waiting for a server patch is usually the best approach.
Open Excel, click on 'File', and navigate to 'Account'. Verify that the email address listed under User Information perfectly matches the Microsoft 365 account that holds your active subscription.
Click 'Sign Out' under your account profile. Close Microsoft Excel completely, reopen the application, and sign back in to refresh your authentication token.
Visit the Microsoft 365 Service Health portal or the Microsoft Community forums online to see if there are ongoing server outages affecting the Stock Data Types feature.
Try WPS Office for Your Spreadsheet Needs
If you are frustrated with Microsoft 365 subscription bugs or ongoing sign-in issues, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for viewing, editing, and managing your spreadsheets without expensive recurring fees.
Frequently Asked Questions
Why does Excel say I need a subscription to refresh stock data when I already have one?
This is often caused by an authentication glitch within the Office app or a known Microsoft service outage. Signing out and signing back into your account, or waiting for Microsoft to resolve their server bug, usually fixes the issue.
Are stock data types available in older standalone versions of Excel?
No, the Stock and Geography data types are exclusive to Microsoft 365 subscription versions of Excel and Excel for the web. They are not available in Excel 2016, 2019, or older standalone versions.
Can I refresh my stock data manually without an internet connection?
No, refreshing dynamic data types like stocks requires an active internet connection to securely pull the latest financial information from Microsoft's partnered data providers.
