Sign-in & Login Problems

Fix Repeated Credential Prompts for SharePoint IQY Files in Excel

Maira MehtabMaira Mehtab Nov 14, 2026 868 views

Question details

The user needs to open or refresh a SharePoint IQY export in Excel without repeated Microsoft 365 credential prompts.

Fix Repeated Credential Prompts for SharePoint IQY Files in Excel
Product
Microsoft Excel and SharePoint in Microsoft 365
Device & OS
not provided
Scenario
A user exports or refreshes a SharePoint list through an IQY file, potentially using a guest account across Microsoft 365 tenants.
Observed behavior
Excel repeatedly requests Microsoft 365 credentials even after valid sign-in information is entered.
Before you start

Identify the SharePoint site and the Microsoft 365 account intended to access it. If the site belongs to another organization, confirm that the guest invitation has been accepted and that the account can open the list in a browser.

Solution 1Recommended

Verify the SharePoint account and guest access

Use this approach when the IQY file comes from another organization's SharePoint site or when account access is uncertain.

1
Test access in a browser

Open the SharePoint site in a private browser window and sign in with the account intended for the export. Navigate to the source list and check that it opens.

2
Check guest permissions

If the list does not open, ask the site owner to check the guest invitation and the account's permissions to the site and list.

3
Check the Office account

In Excel, open File > Account and check which account is signed in. Sign in with the account that has access to the SharePoint site if it is not already listed.

4
Export and test again

Return to the SharePoint list, use Export > Export to Excel if available, and open the newly downloaded IQY file. Try refreshing the resulting connection in Excel.

5
Compare with another user

Ask another authorized user to export or refresh the same list. Share the result with the SharePoint administrator to help distinguish an account-specific issue from a broader site or tenant issue.

Verify the SharePoint account and guest access
Guest access may require administrator review: An organization can restrict external access or require additional authentication. A site or Microsoft 365 administrator may need to review those policies if browser access works but Excel still prompts.
Free Microsoft Office alternative

Work with Excel spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for common Excel formats, making it easier to move existing workbooks. It does not resolve Microsoft 365 tenant authentication or SharePoint IQY refresh issues.

Open and edit Excel-compatible XLSX and XLS filesWork with spreadsheet data in a familiar interfaceMove existing workbooks without changing your everyday file formatUse a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does an IQY export keep asking for my credentials?

Excel may be using saved credentials for a different account or tenant, or the intended account may lack access to the SharePoint list. Test the list in a private browser window and check the signed-in account under Excel's File > Account.

Can an external guest export a SharePoint list to Excel?

A guest may be able to export a list if the invitation is accepted, the account has the necessary permissions, and the organization's policies allow it. Ask the site owner to check access if the list or export is unavailable.

Where can I remove saved Microsoft 365 credentials?

On Windows, open Credential Manager from the Start menu and select Windows Credentials. Remove only entries relevant to the affected Office account or tenant, then reopen Excel and sign in again.

Should I set EnableADAL to 0 to stop the prompts?

That is a legacy workaround that disables modern authentication for Office and can cause Microsoft 365 sign-in to fail. Do not change the registry value without guidance from your IT administrator; check account access and saved credentials first.

Will WPS Office fix the SharePoint sign-in loop?

No. WPS Office can open and edit common Excel workbooks, but it does not fix Microsoft 365 authentication or tenant access. Troubleshoot those issues with the SharePoint site owner or Microsoft 365 administrator.