Tag Info

New answers tagged

0

You can right click on the overview screen and choose export to excel. A new window will pop up. Click on "show a graphical summary of responses" which should open the graphical response page with yellowish arrow tags click on the arrow shown in the picture and it should turn into a green check box This should select all of your survey questions and auto ...


0

You can use OpenXML with SharePoint to generate Excel worksheets. Have a look at following: Creating and Publishing Excel 2010 Documents with Custom SharePoint 2010 Workflows OpenXML Excel Generation - CodePlex


0

You can follow this step-by-step blog to sync Excel with SharePoint (uni-directional): http://www.layer2solutions.com/en/community/FAQs/cloud-connector/Pages/Office-365-Integration-Excel-files-to-cloud.aspx It's especially interesting if frequent updates required automatically scheduled in background.


0

There are no out of the box content types like Excel,PowerPoint,One Note in SharePoint 2013. You need to create your custom content types and add it your document library.


0

I have done same thing using Excel Addin 2013. You can do the same using Addin by writing code of CSOM for SharePoint List. You can use this Event in Addin :- void Application_WorkbookBeforeSave(Microsoft.Office.Interop.Excel.Workbook Wb, bool SaveAsUI, ref bool Cancel) And In this event you can add code like following of mine :- try { ...


0

If you're open to 3rd party web parts, both Collabion, and Nevron have an auto-refresh feature with which you can set the chart to refresh after every x seconds. It can pull data from a List, and is probably the easiest to setup.


1

There seem to be a number of problems related to Document Information Panel. Cite from Technet site with the same Excel problem: If there is a property contained in the Excel file that is stored in SharePoint it will still be contained even if that file is subsequently opened from SharePoint or even if downloaded from SharePoint to your hard disk ...


0

My solution was this: rstagg.com/2010/04/13/how-to-bulk-upload-and-synchronize-data-into-sharepoint-using-the-excel-add-in-and-sharepoint-designer-workflows/ I installed an add-in for excel that let's me sync a data sheet to a list in sharepoint. So I update that data sheet, and then sync the data with it. So far it seems to do the trick.



Top 50 recent answers are included