SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm working with WSS 3.0 and have access to a number of sites within SharePoint.

I and a number of other users have run into an issue that is happening when we try export a list using the "Export to Spreadsheet" option.

The export creates a .iqy file which is then opened in Excel 2007. Once Excel opens, there is a prompt to enable the data connection. I click "Enable".

Excel then tries to connect to the site but hangs in the end and cannot open the file.

How to solve this issue?

Please help!


ps --- My System is Office 2007, Windows 7, WSS 3.0 & IE 8.0

share|improve this question
Are you sure you don't have some proxy restriction s in your environment? – Patrick Jan 18 '11 at 11:54
up vote 2 down vote accepted

I have had this same issue. For me it was caused by authentication not working correctly between the browser and office. When you get the hang, see if you can minimise the window, then redisplay it. Usually there is a authentication box hiding somewhere.

First, im going to assume this is an intranet?

Close all your browsers, when you go to the sharepoint site, does it ask you for a username and password?

If it does, you need to correct that by setting up your browser zones. IE -> Tools -> Internet Options -> Security. Make sure the site is in local intranet (trusted sites might work too)

Close the browser and try again, you should be automatically logged on.

If that doesn't work, then are are more methods you can try

share|improve this answer

I haven't run into this issue myself, but you could look at OfficeWriter from SoftArtisans. It can export a SharePoint list to an Excel file, but by default doesn't maintain any sort of data connection back to SharePoint. It's a lot more flexible than the SharePoint "Export to Excel" function... you can have custom Excel templates that let you brand the exported list. You can also use other Excel features (like formulas, charts, conditional formatting, etc.). There's information about it on their site at

Full Disclosure - I work for SoftArtisans.

share|improve this answer
Thanks Chaulky!! Was looking for a free option!! Anyways, thanks for your help!1 – neo269 Nov 23 '10 at 12:08

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.