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

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

Unable to see Export spreadsheet option under Actions Menu in Surveys

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :SharePoint
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

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

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

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?

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


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.

RDLC Report Hide Export Option

The article RDLC Report Hide Export Option was added by mandandeo on Sunday, August 15, 2010.

protected void ReportViewer1_PreRender(object sender, EventArgs e) {DisableFormat(ReportViewer1, "Pdf"); }protected void DisableFormat(ReportViewer viewer, string formatName) {const System.Reflection.BindingFlags Flags =System.Reflection.BindingFlags

Displaying the Server Ribbon and Site Actions Menu on Customized Search Pages Upgraded to SharePoint

Learn how to add the Site Actions menu and SharePoint Server ribbon to SharePoint Server 2007 search pages that you upgrade to SharePoint Server 2010 by using visual upgrade.

No "Site Actions" Menu Available in Sharepoint 2007

I installed Sharepoint Designer 2007 on my home pc. It does not have the "Site Actions" menu. I originally created my Web site (I upload files via FTP) using MS Frontpage. How do I change the theme created in MS Frontpage? Or, how do I find the "Site Actions" menu?

Any help will be appreciated.

B Goldberg

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 load workflow actions from the server - problem!

Hi, I have problem on Sharepoint 2010 RTM (new installation). I use workflows from the begining and I had no problem since yesterday. I tried to make custom workflow and the SP designer has frozen when saving it. Since than I get message "unable to load workflow actions from server. Please contact your server administrator." every time I want to customize or make new workflow. Need fast solution, Please help. Regards, Luka

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 load workflow actions from the server.

When I try to create a workflow in SPD for my teamsite (for which I have full control) I get the above error message. I have read many posts on this topic but am not conviced that what I usually see about the actions not loading applies to my case beacusewe have a developer logging in remotely that is able to create a workflow in the same site using SPD.  I have .net 3.5 framework, I have full control permissions, and the wss.actions file is not bad in that it is obviously loading for the remote developer, what else could be causing this error? I find no error messages in the SharePoint logs nor the application logs although the sharepoint logs are throttled back.

Add "New Calendar" to the site actions menu in SharePoint 2010

I really like how SharePoint 2010 uses Silverlight to allow users to create a new Document Library from the Site Actions menu.  I would like to alter the v4.master page and add a new menu item to the Site Actions menu that allows the user to create a new Calendar.  How do I alter the code below to make a new menu item that will create an events list? <SharePoint:MenuItemTemplate runat="server" id="MenuItem_CreateDocLib" Text="<%$Resources:wss,siteactions_createdoclib%>" Description="<%$Resources:wss,siteactions_createdoclibdesc%>" ImageUrl="/_layouts/images/NewDocLibHH.png" MenuGroupId="200" Sequence="220" UseShortId="true" ClientOnClickScriptContainingPrefixedUrl="if (LaunchCreateHandler('DocLib')) { GoToPage('~site/_layouts/new.aspx?FeatureId={00bfea71-e717-4e80-aa17-d0c71b360101}&amp;ListTemplate=101') }" PermissionsString="ManageLists" PermissionMode="Any" VisibilityFeatureId="00BFEA71-E717-4E80-AA17-D0C71B360101" />

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

I am a Site Administrator, but I do not see Site Settings or Edit Page menu from Site Actions

Hi, I have been using MOSS for over 2 years, but I have not even heard or seen this kind of situation. I am a Site Administrator, but I do not see Site Settings or Edit Page menu from Site Actions menu, and I typed in http://mysitecollection:portnumber/_layouts/settings.aspx to go to setting page manually and looked around there. I confirmed that I am the site administrator, but when I go to Advanced Permissions, I do not see any checkbox beside each users. So basically, I am a Site Administrator on the site, but I am really NOT! What is going on here!? 

how to hide site actions menu

Hey, Just wondering if anyone can help me try and hide the Site Actions menu either by using a HTML Form Web Part or changing the master page. Cheers
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