Fix Repeated Credential Prompts for SharePoint IQY Files in Excel
Question details
The user needs to open or refresh a SharePoint IQY export in Excel without repeated Microsoft 365 credential prompts.

- 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.
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.
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.
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.
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.
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.
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.
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.

Remove relevant saved credentials in Windows
Try this when Excel on Windows may be reusing credentials from a different Microsoft 365 tenant.
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.

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.




