.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Unable to export to spreadsheet

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :SharePoint



Moss 2007 -


When we are trying option export to spreadsheet from the below site, the following error displays


 " Cannot connect to the server at this time. Changes to your data cannot be saved" (message box it displays).


Not working on VISTA SP1 systems only


View Complete Post

More Related Resource Links

Unable to see Export spreadsheet option under Actions Menu in Surveys

Created 30 surveys expected one survey every survey has Export spreadsheet option.The one which doesn't have Export Option has 924 Responses. I think there is no problem with FBA.Please let me know how to resolve. Thanks

Unable to Export to Spreadsheet in SharePoint Form Library


Hi All,

I am unable to export SharePoint Form Library view data in a Spread Sheet. Whenever I am trying , I got following error message.

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 if it is, reinstall the driver by reinstalling Microsoft Query. For other drivers, contact your database administrator or driver vendor.

Any idea how to solve the problem ?

Muhammad Tariq khan

Unable to Export to Spreadsheet in SharePoint if record Count increase more than 1100


Hi All,

When I am trying to export the SharePoint View from SharePoint site to Spreadsheet, sometimes I am able to export the the whole data and sometimes I only get Column headers but no data or records

I have Infopath form (2007) published on SharePoint Site and I am using MOSS 2007 and Excel 2003

I am not able reach the cause of this behaivour of Export to Spreadsheet functionality

Is their a Buffer size Issue with IIS or Session time out

I am not sure because when I export to Spreadsheet and if the record goes to Spreadsheet the file size is just 1.72 MB

Please suggest

Hitesh Duggal

Export SharePoint List to Excel Spreadsheet Programmatically using C#

In SharePoint applications, Custom Lists are used to store business data and Document Libraries to store the documents. But for data manupulation and analysis, Microsoft Excel provides very rich features as compared to SharePoint Lists. That's why people still loves to work on Microsoft Excel Sheets.

Document Library "export to spreadsheet" doesn't export all columns in Excel 2003

Hi, we are working with MOSS 2007, Infopath Forms Services, KPIs and Excel 2003. There is a view for some data of the Infopath forms which has to be exported to Excel by our users, but some columns are not exported - without any error message. If I try to export it to Excel 2007 everything is exported as expected, but our users have to use Excel 2003. Any idea?

Unable to export/copy documents out of SharePoint 2007 libraries

Hi, A client had an issue a few months ago where their MOSS 2007 home site collection had to be restored after a major crash, it now works but they have loads of issues with the restored site(no need to go into) now I am trying to migrate the Data (files and folders only, no security or metadata) to a SharePoint 2010 installation, the problem is that I am unable to get any of the files out of SharePoint. I decided against an upgrade or any form of site migration as I might only be taking the problems with me. i am just trying to copy the files using the "Library - Actions - Open with Windows Explorer". The Explorer view window opens but if i select a file and move it into a folder on the server nothing happens, If I select a folder with files and folders in it then only the root folder is copied over but it is empty.  i don't want to repair any of the issues with the old site as it's only wasting time, can anybody think of a way to get all of the data out of Sharepoint 2007, without taking any of the lists or libraries or any other Sharepoint settings. I only need to keep the folder structure and files within them as i don't need any metadata and am recreating the security again seperately on the new SharePoint setup. Anybody have any ideas or know of free/trial products that i

Unable to export data to an excel file in grid format!!!

I'm exporting data to an excel sheet from the ojects list. The data is exporting to excel sheet well, but I'm unable to see the grid format for the data. The data is looking with out the rows and columns lines. I think I'm missing to set some property or somethnig ehwn exporting.   Any help would be really appriciated.

Sharepoint export to spreadsheet gives two extra columns in excel 2007 named as type and path, is th

When i export a list in excel 2007, it creates two extra columns named as type and path. At the same time this behaviour is not exhibited in office 2000. Is there any way to remove these two columns without using code ? Is there any configuration settings required for this, to remove it on the fly ? Thanks Ravish Verma

Lookup fileds with allow multiple values option enabled are separated by ;# in export spreadsheet


The lookup fields with allow multiple options enabled displays parent listitem id separated by ";#" when exporting to spreadsheet. I need to remove the #and the parent list item id from the spreadsheet. how to achieve that?

Any suggestions?

SSRS 2008 - Excel Export adding unwanted total columns to spreadsheet



I have a SSRS 2008 report which has 3 column groups which when i export to Excel the resulting excel spreadsheet has an additional total column for each of the groups.  I dont have this displayed in the report and dont want it displayed in teh excel export, is there anyway to turn this off?

I've had a search of this forum but so far i've been unable to find a solution(or someone else having the same problem)


Sharepoint survey- feature for export to spreadsheet


Hi All

I am working on sharepoint survey and I want to extend the functionality EXPORT TO SPREADSHEET of survey list. By default when I click on EXPORT TO SPREADSHEET  option it generates an MS Excel sheet with multiple columns. There is a column Created By in which default value is System Account.

I want to change this default value with currently login user`s Logon Name. Is this possible?

Is there any custom feature for this?


Export to spreadsheet fails in certain views



WSS3.0 sp2 server with client running Excel 2003 sp3

We have a list based on a calender with just over 2000 items. There are multiple views for this list. When we try to export to spreadsheet it works fine on most views but on one particular view we only get the column headings appearing in the spreadsheet. The view in question is configured for sorting and grouping on the same column - a date column as it happens.

Changing the column used to either sort or group results in export to spreadsheet working fine so it appears to be using the same column to both sort and group that is causing the problem. 

If we try to create a similar view (i.e. using the same column for sort and group) on a different list (also based on a calender) then the export works fine.

Can anyone shed any light on this?





Export to Spreadsheet and forms based authentication

Is this even possible?  We are allowing client integration but when I try to export, Esxcel 2007 and Excel 2010 both say they can't connect to the site. A custom form is being used.

Sharepoint 3.0 - Export to Spreadsheet - owssrv.dll


Caveat: New to SP, just took over this in the wake of our current sysadm's departure.


So users want to export lists/libraries data to spreadsheet. They get a "To export a list, you must have a Windows SharePoint Services-compatible application." and when you click ok, it downloads owssvr.dll

I have no idea what to do with this, and the lack of information when searching the two subject together do not produce solid information.

Please assist. Working with office2007 on the client machine.

Export Visio Database Table Names to Excel

If you use the Enterprise Architect edition of Microsoft Visio for data modeling regularly, then there is a good chance that at some point you've wanted to export just the table names into Excel. You might want to do this to map logical ERD entities to physical data model tables, track project status by entity, or track overlap between database versions.

Creating an Excel Spreadsheet programmatically using VB.NET

The Interoperability services make it very easy to work with COM Capable Applications such as Word and Excel. This article reveals using Excel from a managed application. Excel is the spreadsheet component of Microsoft Office 2000. The majority of Excel programmatic functionality is exposed through Automation via the type library Excel9.olb. The intention of this article is to express that a managed application can interrelate with Excel as a COM server.

Creating an Excel Spreadsheet and Adding Data to It Programmatically

The Interoperability services make it veryeasy to work with COM Capable Applications such as Word and Excel. Thisarticle reveals using Excel from a managed application. Excel is thespreadsheet component of Microsoft Office 2000. The majority of Excelprogrammatic functionality is exposed through Automation via the typelibrary Excel9.olb. The intention of this article is to express that amanaged application can interrelate with Excel as a COM server.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend