'%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 Stock and Geography Data Type Sign-In Errors
Question details
Users encounter a recurring sign-in error prompt when attempting to refresh Stock or Geography data types in Excel, despite having an active Microsoft 365 subscription and already being signed into their account.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Refreshing linked connected data types (Stock or Geography) within an Excel workbook.
- Observed behavior
- Excel blocks the data refresh process and displays a prompt asking the user to sign in, even when the user is already authenticated with a valid Microsoft 365 subscription.
Ensure your device is connected to a stable internet connection and verify that your Microsoft 365 subscription is currently active, as these connected data types require both to function.
Re-sync Your Microsoft 365 Account and Update Office
Resolves temporary account synchronization glitches by forcing Excel to refresh your login credentials and apply the latest application patches.
Account token expiration or local software glitches can cause Excel to fail in verifying your subscription status. Signing out completely and updating the software usually resets this connection.
Click on 'File' in the top ribbon of Excel and select 'Account' (or 'Office Account') from the left-hand menu.
Under the User Information section, click the 'Sign Out' button and confirm your choice to remove the current session.
Close the Excel application completely, reopen it, navigate back to 'File' > 'Account', and click 'Sign In' to re-enter your Microsoft 365 credentials.
While still in the Account menu, click 'Update Options' and select 'Update Now' to install any pending Microsoft fixes.
Verify Microsoft Service Health Status
Determines if the sign-in prompt is caused by a widespread server-side outage rather than a local application error.
Experience a Lighter, Seamless Office Alternative with WPS Office
If you are tired of dealing with account synchronization errors, constant sign-in prompts, and subscription-tied features in Microsoft Office, try WPS Office. It provides a robust, lightweight, and completely free alternative for your daily spreadsheet needs, ensuring high compatibility with Excel files without the hassle of mandatory cloud connections.
- 1. Download the Installer: Visit the official WPS Office website to download the free installation package for your operating system.
- 2. Install WPS Office: Run the downloaded installer and follow the simple on-screen instructions to set up the software.
- 3. Open Your Workbooks: Launch WPS Spreadsheet and open your existing Excel workbooks to continue your work seamlessly.
Frequently Asked Questions
Why does Excel keep asking me to sign in for Stock data types when I am already signed in?
This usually happens due to a disruption in the communication between Excel and Microsoft's connected services. It is often caused by expired login tokens on your local machine or temporary server outages at Microsoft affecting connected experiences.
Can I use Geography data types without a Microsoft 365 subscription?
No, the Stock and Geography data types are premium connected features. They require an active Microsoft 365 subscription and an internet connection to retrieve and refresh data from external sources.
How long do Microsoft service outages usually last for data types?
Most temporary service interruptions or synchronization bugs are resolved by Microsoft within a few hours. You can monitor the Microsoft Tech Community for official updates if the issue persists.
Will I lose my existing Stock or Geography data if I can't sign in?
No, your existing data remains safely stored in your spreadsheet. You simply will not be able to refresh the cells or pull new updated information until the sign-in issue or service outage is fully resolved.
