Hi, I'm working with SharePoint 2007 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 returns the error: Microsoft Office Excel An operation that uses the database driver could not be completed. If the driver is a Microsoft driver, make sure the driver file isn't damaged, and it it is, reinstall the driver by reinstalling Microsoft Query. For other drivers, contact your database administrator or driver vendor. I've searched a lot but cannot find a way to resolve this. Can anyone here help please? We also have a similar issue with the "Edit in Datasheet" option here for the same list which I've also posted in this group. Thanks in advance. Chris

We are having the same issue. Were you able to resolve?

Anyone find an answer for this? We're seeing the same thing, on multiple client machines. Looks like the FrontPage API is hosed on the server? How do we get this back to normal?

Oops, I should clarify, this is bombing out for a largish list (18K items with ~30 columns), but not on smaller lists

Has anyone found a solution to this issue? I am having the same problem, but it only happens when I export from a view with an item count > 0. If I have a view with a filter that returns 0 items, the export works fine, but add items (1 or more)tothe mix and it barfs.Also, this only happens on lists created from a custom list template and happens with 1 or more items in the list.Thansk for any help.

Anyone been able to resolve this? Driving me nuts now. All I can see now is that there is an HTTP 500 error returned from the server (monitoring with Fiddler)

I now have this problem as well.I have 11 columns + 1 calculated column.There are approx 8500 items in the listIt *only* seems to affect views of the list where grouping is enabled. If I turn off grouping it exports to spreadsheet fine.Any news on this would be appreciated.Regards, J.Software Consultant - DWS

Hye James, Currently, im having same problem like urs. I would like to try ur solution but i couldn't find where the grouping options is. Appreciated if you could help me in this matter. Regards, K

Hi K, I guess this problem can be solved by restarting the sharepoint timer service from the services console. You can find grouping option once you will click on any of the link on the view dropdown and scroll down in that page. Thanks Ravish Verma

Ravish Verma: Don't propose your own posts. Do propose other people's posts but only where they provide a good answer. "Currently, im having same problem like urs.I would like to try ur solution but i couldn't find where the grouping options is." is NOT an answer. It's not even English. (Moderator) FAQ sites: (SP 2010) http://wssv4faq.mindsharp.com; (v3) http://wssv3faq.mindsharp.com and (WSS 2.0) http://wssv2faq.mindsharp.com Complete Book Lists (incl. foreign language) on each site.

Had the same issue, Issue got fixed when I set the group by option to none.Where the group by option is ?On the right side on the list u will find an option View > Drop down the view > Select modify this view > Scroll down >U will find the Group by option > set that to none will do the trick.Thanks Kanieza

Tom, You are thanking (and proposing as answer) the wrong person. This is Kanieza's post ------------------Currently, im having same problem like urs.I would like to try ur solution but i couldn't find where the grouping options is.Appreciated if you could help me in this matter.------------------ where's the answer in this post ? FAQ sites: (SP 2010) http://wssv4faq.mindsharp.com; (v3) http://wssv3faq.mindsharp.com and (WSS 2.0) http://wssv2faq.mindsharp.com Complete Book Lists (incl. foreign language) on each site.

Can you create the New View and Try "Export to Spreadsheet" based on the created New View. I think it should work.