How to Fix Excel Credential Prompts When Opening SharePoint IQY Files
Question details
The user needs to stop Excel from repeatedly prompting for credentials or showing server connection errors when attempting to open an exported SharePoint IQY file.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Exporting a SharePoint list to an IQY file and opening it in Excel to view or manipulate the data.
- Observed behavior
- Excel gets stuck in an authentication loop, repeatedly requesting user credentials or throwing a server connection error instead of displaying the SharePoint list data.
Verify your internet connection and check if the IQY file opens successfully for other users in your organization to determine if the issue is device-specific.
Enable Modern Authentication for Office 2013
Updating the authentication protocol can resolve compatibility issues between older Office versions and modern SharePoint servers.
Microsoft has updated SharePoint to use modern authentication protocols, which are not enabled by default in older applications like Office 2013. If you must use Excel 2013, you need to manually enable modern authentication via the Windows Registry so that the application can securely connect to Microsoft 365 services.
Press the Windows key + R, type 'regedit' in the Run dialog box, and press Enter to open the Windows Registry Editor.
Go to the path: HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Common\Identity.
Right-click in the right pane, select New > DWORD (32-bit) Value. Name it 'EnableADAL' and set its value to 1. Create another DWORD named 'Version' and set its value to 1.
Close the Registry Editor and restart your computer. Open the IQY file again with Excel 2013 to see if the credential prompt resolves.

Upgrade or Test with Microsoft 365 Apps
Newer versions of Excel natively support modern SharePoint authentication, bypassing the credential loop entirely.
Clear DNS Cache and Isolate Network Issues
Flushing the DNS cache and changing networks can fix underlying connection errors preventing Excel from reaching the server.
Switch to WPS Office for a Modern, Seamless Experience
If you are tired of dealing with legacy authentication bugs, credential loops, and connection errors in outdated versions like Office 2013, it's time to upgrade. WPS Office offers a free, lightweight, and modern office suite that easily handles complex data and is fully compatible with Microsoft Excel formats.
- 1. Download and Install WPS Office: Visit the official WPS website, download the free installer, and complete the quick installation process.
- 2. Open WPS Spreadsheet: Launch WPS Office and click on 'Spreadsheet' to open the modern spreadsheet application.
- 3. Import Your Data: Easily open your existing Excel workbooks or import your web data directly without dealing with outdated software errors.

Frequently Asked Questions
What is an IQY file in Excel?
An IQY file is an Internet Query file used by Microsoft Excel to pull raw data directly from external web sources, most commonly used for exporting and syncing data from SharePoint lists.
Why does Excel keep asking for my password when opening SharePoint files?
This credential loop occurs when the software fails to pass a valid authentication token to the server. It is common when using outdated software like Office 2013 that lacks default support for modern SharePoint authentication protocols.
Is Office 2013 still fully supported for SharePoint Online?
No. Microsoft has ended mainstream support for Office 2013. Consequently, it may experience persistent connection and compatibility issues with modern Microsoft 365 services like SharePoint Online.
Can I view the contents of an IQY file without Excel?
Yes. An IQY file is simply a plain text file containing a web query URL. You can open it with Notepad or any text editor to view the source URL, and then paste that URL into a web browser to see the raw data.




