Query list with Excel Error (Windows cannot find .iqy)


A great many people experience this issue and it’s hard to find an answer/resolution for it. When you open the task pane in a SharePoint list and choose Query list with Excel you receive an error with something similar to the following: “Windows cannot find ‘C:\Users\Username\AppData\Local\Temp\Low\list6856.iqy’. Make sure you typed the name correctly, and then try again.”

exceltasksheet

exceltaskerror

The reason you get this message? Odds are your Internet explorer settings have protected mode on, and/or you don’t have the SharePoint address set as a trusted location.

So it’s VERY easy to fix, just turn off protect mode, or add it to trusted sites, or local intranet (if that makes sense) and set those zones to have protected mode off (you don’t need protected mode on a local intranet, trust me).

protectedmode

Do this and you should be golden and the issue should go away.

Hope this helps someone,
Richard Harbridge

Advertisements
Explore posts in the same categories: Administration, Issue Resolution, SharePoint 2007, Troubleshooting

Tags: , ,

You can comment below, or link to this permanent URL from your own site.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: