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
January 31st, 2008 7:32pm

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 10:03am

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 9:30am

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 10:18am

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 2: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 6:09am

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 4: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 5:52am

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 7:08am

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 7:12am

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 12: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 1: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:22am

I recreated a view and removed the groupings and I am still experiencing this issue. Has anybody found a resolution to this? I have many pivot table reports and charts that an entire department depends on and this is creating such a headache.
Free Windows Admin Tool Kit Click here and download it now
October 21st, 2011 3:32pm

I've experienced this issue as well. I've been able to export by creating a new view. First, I started out with just the Title field, but gradually added additional fields. It turns out, the export was prevented by a text field. Field Information: Title: State/Province Internal Name: State/Province Type: Single line of text Maxinum length: 255 The column isn't storing any value that seems inappropriate, just general dual-letter state codes and the occasional province name. I was able to remove this column from my view and export the list successfully. I'm still not sure why it stopped working, but I'm examining the logs and will post any findings. Update 10-24-2011: I assume it fails because of the '/' character in the name of the field. I don't remember exporting this list before so I'm not sure if we could export before now. The correct XML is being returned from the Lists.asmx web service (so says Fiddler2). But the XML is probably invalid due to the column name, which is listed as an element property of "ows_State/Province='TX'" http://donahoo-development.com
October 24th, 2011 5:38pm

I am experiencing the same issue as well. But if I use another View that has fewer columns, that View does export and Open in Excel. My List has about 1700 items and about 35 columns with about 15 calculated columns and 6 or so columns created by same many workflows attached to the List. I have tried all of the above solutions and the List (with original all column View) will Not open in Excel: Reduced number of columns all the way down to only 1 column (and switched that 1 column). Nope.Was already no Grouping but I also clicked on the Show Expanded by default option anyway. Nope.I have no illegal characters in List Column Names or the Lookup Lists either. Nope.Working as Site Admin/Designer so not have option to "solved by restarting the sharepoint timer service from the services console". N/A. However other Lists on same site export and open in Excel just fine, so unlikely to be a Server problem. I noticed that doing like edoughig did above and Filtered List so have 0 records, then it does Export and Open in Excel even with all columns. Furthermore, if filter for Modified < 4/1/2012 (when was opening in Excel) then the resulting fewer records DOES export and Open in Excel. I guess I should look at the individual records for odd data. Or maybe there is some kinda List size limit I'm hitting? Any more ideas of what to try?
Free Windows Admin Tool Kit Click here and download it now
May 10th, 2012 5:01pm

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

Other recent topics Other recent topics