Permission & Access Issues

Fix Excel Repeatedly Asking for a Microsoft Account to Open a File

Muhammad TalhaMuhammad Talha Nov 3, 2026 873 views

Question details

The user is encountering repeated prompts for Microsoft account credentials and seeing #REF! errors when attempting to open a shared workbook.

How to Fix Excel Repeatedly Asking for a Microsoft Account to Open a File
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the Edit Links Dialog

Open the affected workbook. Navigate to the 'Data' tab on the Excel ribbon and click on 'Edit Links' in the Queries & Connections group.

2
Select the External Links

In the Edit Links dialog box, review the list of source files. Select the linked workbooks that belong to the external organization.

3
Break the Links

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.

4
Save the Workbook

Close the Edit Links dialog and save your workbook. The repeated Microsoft account prompts should no longer appear upon reopening.

Inspect and Break External Links
Important: Breaking links will prevent future updates from the source file. Ensure you no longer need dynamic updates before performing this step.
Free Microsoft Office alternative

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.

100% compatible with Microsoft Excel formats (.xls, .xlsx, .csv)Open and edit local files without mandatory account sign-insLightweight software that loads large, complex workbooks quicklyFamiliar spreadsheet interface that requires zero learning curve
QA img-9

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.