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!
-saumil
ps --- My System is Office 2007, Windows 7, WSS 3.0 & IE 8.0