Fix Excel Repeatedly Asking for a Microsoft Account to Open a File
Question details
The user is encountering repeated prompts for Microsoft account credentials and seeing #REF! errors when attempting to open a shared workbook.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Opening an Excel workbook received from another organization that contains external data references or restricted permissions.
- Observed behavior
- Excel repeatedly demands a Microsoft account sign-in to view the file, and some cells fail to display data, showing #REF! formula errors instead.
Ensure you save a backup copy of the original workbook before attempting to break any links or replace formulas, as these actions are permanent and cannot be easily undone if the data is lost.
Inspect and Break External Links
The sign-in prompts are often triggered by formulas linking to files hosted on another organization's Microsoft 365 SharePoint or OneDrive. Breaking these links converts the formulas to static values and stops the prompts.
When an Excel file contains links to workbooks you do not have permission to access, Excel will continuously ask you to authenticate. Breaking the links will sever the connection and keep the current values.
Open the affected workbook. Navigate to the 'Data' tab on the Excel ribbon and click on 'Edit Links' in the Queries & Connections group.
In the Edit Links dialog box, review the list of source files. Select the linked workbooks that belong to the external organization.
Click the 'Break Link' button on the right side of the dialog box. Confirm the action when Excel warns you that formulas will be converted to values.
Close the Edit Links dialog and save your workbook. The repeated Microsoft account prompts should no longer appear upon reopening.

Use Paste Special to Preserve Data and Fix #REF! Errors
If breaking links or missing source files results in #REF! errors, you can copy the data directly from a working version of the file as plain values.
Bypass Microsoft Account Sign-in Hassles with WPS Office
If Microsoft Excel continues to interrupt your workflow with forced account logins and permission issues, switch to WPS Office. It is a highly compatible, free alternative that allows you to open, view, and edit local Excel files without needing an active Microsoft 365 subscription or a mandatory cloud login.

Frequently Asked Questions
Why does Excel keep asking me to sign in when I open a specific file?
This happens when the workbook contains external links, embedded objects, or macros connected to files stored on a secure cloud service (like SharePoint or OneDrive) belonging to another organization. Excel prompts you to sign in to verify you have the correct permissions to access those linked resources.
What causes the #REF! error in Excel cells?
The #REF! error stands for 'invalid reference'. It occurs when a formula attempts to calculate a value using a cell, worksheet, or linked workbook that has been deleted, moved, or is blocked by account permission issues.
How can I find which cells contain external links causing these errors?
Press Ctrl+F to open the Find dialog. In the 'Find what' box, type '[' (an open bracket) or '.xl' and click 'Find All'. This will list every cell in your workbook that references an external file, helping you identify where the broken links or permission issues originate.
Can I recover the #REF! data if I cannot access the external links?
If the workbook was saved after the #REF! errors appeared, the original values calculated by the formulas are typically lost. You will need to request an untouched version of the file from the original sender and immediately use 'Paste Special > Values' to capture the static data.




