'%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)
Fix Excel Work or School Account Sign-In Error When Updating Links
Question details
The user encounters a prompt stating that work or school accounts cannot sign in when trying to update external links in an Excel workbook.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Updating external workbook links that point to a source file stored in a personal OneDrive account while using an organizational account.
- Observed behavior
- Excel displays a sign-in error for the work or school account. Dismissing the prompt allows the user to continue editing the file, but prevents the linked data from refreshing.
Verify whether the source workbook is currently saved in a personal OneDrive account or an organizational OneDrive/SharePoint account, and note which Microsoft account you are actively signed into in Excel.
Relocate the Source File and Update External Links
Move the source workbook to a location accessible with your organizational credentials to bypass the account conflict.
Excel prevents cross-authentication between organizational accounts and personal OneDrive environments for security reasons. The most effective fix is to ensure both the main workbook and the source workbook reside within the same organizational cloud environment.
Find the source workbook that is currently stored in your personal OneDrive account.
Download the source workbook and upload it to your organizational OneDrive for Business or SharePoint document library.
Open the main workbook in Excel. Navigate to the Data tab on the ribbon and click on 'Edit Links' in the Queries & Connections group.
Select the broken link pointing to the personal OneDrive, click 'Change Source', and browse to the new location of the source file in your organizational account to re-establish the connection.
Break the External Link to Retain Current Data
If you no longer need the linked data to update automatically, you can break the link to stop the error prompt.
Avoid Complex Account Errors with WPS Office
If strict Microsoft account separations between personal and work files are causing external link errors and slowing down your workflow, consider switching to WPS Office. It provides powerful spreadsheet capabilities without restrictive cloud account barriers.
Frequently Asked Questions
Why does Excel ask me to sign in with a work or school account when updating links?
This occurs when your active Excel session is logged in with an organizational (work or school) account, but a formula in your workbook attempts to pull data from a file stored in a personal OneDrive. Microsoft's security protocols prevent organizational accounts from authenticating into personal cloud storage seamlessly.
Can I keep the source file on my personal OneDrive and still update the link?
To update the link automatically without moving the file, you must sign out of your work/school account in Excel and sign back in using the personal Microsoft account associated with the source file's OneDrive location.
How do I find which cells contain external links in my Excel workbook?
Press Ctrl+F to open the Find and Replace dialog. Type '[' (an opening bracket), click 'Options', set 'Look in' to 'Formulas', and click 'Find All'. External links to other workbooks typically contain bracketed file names, making them easy to spot.
Will breaking the link delete the data in my spreadsheet?
No, breaking the link will not delete the data currently visible in your cells. However, it permanently replaces the dynamic linking formulas with their current static values, meaning the numbers will no longer update if the source file is changed in the future.
