.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 in SharePoint if record Count increase more than 1100

Posted By:      Posted Date: October 22, 2010    Points: 0   Category :SharePoint

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

View Complete Post

More Related Resource Links

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

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.

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 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

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

Unable to export to spreadsheet




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


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?


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.

Configuring Profile Image Export in SharePoint 2010

It's no secret that I am thrilled with the new social features of SharePoint 2010. I am most excited about the new Profile Picture handling. I strongly believe that the more we can show the faces of our colleagues to one another the more connected we will feel. Clearly Microsoft feels that way as witnessed by the many features that make use of the Profile Image like the Activity Feed and Colleagues list

Unable to search Custom User Property Created in User Profiles in SharePoint 2010


Hi ,

I have created a custom user property,and created metadata property and added mapping to it, still i m not able to Search in People,Please advise

Cannot export from a Report in SharePoint integrated mode in a server hardend environment


We have installed Reporting Services 2008 integrated with MOSS with SQL Server 2008 on a 64 bit platform.

The environment has worked fine in test (but the servers are not hardend).

With the production environment, any attempt to export from a report into another format (eg excel, tiff etc) results in an unexpected error within SharePoint requiring closing the browser and reopening.

There are no details behind the error. We can also find no traces of the error within any of the logs (SharePoint, Reporting Services, Windows event log etc)

When the report is opened directly from Reporting Services (ie http://servername:8080/reportserver) the report exports fine. Similarly, if the report is opened directly from Report Builder 2, or through opening Report Builder 2 from SharePoint there is no issue. This issue only happens when the report is invoked directly through SharePoint.


We can only assume that this issue has something to do with server hardening/UAC as we have

SharePoint 2007 uploading document limitation <=6 record ??

Dear Expert, I've 1 project of sharepoint which is involved a scanning solution + sharepoint (document library) People will scan a set of invoice thru scanning device and then export to sharepoint (document library) as a PDF file. 1 invoice may have many sheet, but our scanning solution will group it into 1 and save as 1 pdf. After upload to sharepoint (document library) my Workflow will start to running and routing for approval But if they upload more than 6 invoice then the 7th invoice will get a error on WF to start (intermittent case).  Isit sharepoint have a limitation number of uploading??  

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 delete a column from library in sharepoint 2007

Hi When deleting  any column in document library we are getting the below error Unable to validate data.   at System.Web.Configuration.MachineKeySection.GetDecodedData(Byte[] buf, Byte[] modifier, Int32 start, Int32 length, Int32& dataLength)    at System.Web.UI.ObjectStateFormatter.Deserialize(String inputString) Also tried to hide/remove the search content place hoder in master page but nothing works. Removed our custom master page with default master page still no changes are being observed. Thanks & Regards. Prerna

Unable to Use ToolkitScriptManager in Sharepoint 2010 webparts

I am trying to use ajax in my sharepoint 2010 webparts. Tried to add a calenderextender to textbox. But  the ajax funcationality is coming in to picture if i use only ToolkitScriptManager , but not for ScriptManager.(as i tested in visual studio 2010) The v4.master has got <asp:scriptmanager ... /> already.  So i can'nt add another scriptmanager(ToolkitScriptManager). Any help please?  

How to export data from a sharepoint list to a SQL database

hi, is it posible if i add some data in a sharepoint list that i can export these data to my sql server tables. or if i create a dataview for exapmle from databse A in SPD to use in my wss3 site and then export it to database B in sql server? thnx

Unable to collaborate on document in SharePoint Workspace which has Content Type with more than look

1/ Add a new document into Shared Document library. 2/ In Shared Document of this workspace, add new content type having 12 lookup columns. 3/ Create a new workspace 4/ Add a user into the workspace with the editable permission (Contribute or Full Control). 5/ Open the document in Word 2007, in the Document Management Pane Using system account: the document is shown in the Document tab. Using normal account: the document is not shown in the Document tab. 6/ If we use Dws.GetDwsMetaData method to get information of the workspace site and lists it contains then:    + Using system account credential, this method returns the document's information in Shared Document library. The result contains the below xml data: <List Name="Documents"> <ID>{CFEDFC3C-2AD3-4A0E-88B6-821BF57CACDB}</ID> <z:row ows_FileRef="Shared Documents/Test Content Type.docx" ows_FSObjType="0" ows_Created="2010-09-01T02:38:31Z" ows_Author="1073741823;#System Account" ows_Modified="2010-09-01T02:38:31Z" ows_Editor="1073741823;#System Account" ows_ID="1" ows_ProgID="" xmlns:z="#RowsetSchema" /> </List>     + Using the normal user credential, this method does not return the document information in Shared Document library. I notice
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