Error following export to spreadsheet
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
February 1st, 2008 3:32am

We are having the same issue. Were you able to resolve?
Free Windows Admin Tool Kit Click here and download it now
August 11th, 2008 5:03pm

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?
October 2nd, 2008 4:30pm

Oops, I should clarify, this is bombing out for a largish list (18K items with ~30 columns), but not on smaller lists
Free Windows Admin Tool Kit Click here and download it now
October 2nd, 2008 5:18pm

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.
March 25th, 2009 9:48pm

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)
Free Windows Admin Tool Kit Click here and download it now
June 11th, 2009 1:09pm

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
July 21st, 2009 11:03am

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
Free Windows Admin Tool Kit Click here and download it now
October 17th, 2009 12:52pm

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
December 8th, 2009 3:08pm

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.
Free Windows Admin Tool Kit Click here and download it now
December 8th, 2009 3:12pm

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
December 17th, 2009 8:48am

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.
Free Windows Admin Tool Kit Click here and download it now
December 17th, 2009 9:19am

Can you create the New View and Try "Export to Spreadsheet" based on the created New View. I think it should work.
March 16th, 2011 3:27am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics