Hot answers tagged

10 votes

Exporting SharePoint Members into Excel

Below worked for me: Steps: 1) Open Excel File. 2) Go to ribbon, select DATA and select From Other Sources, and click on From OData Data Feed. 3) In ‘Data Connection Wizard’ form, provide ...
8 votes
Accepted

Excel VBA code to upload document into SharePoint online 2013

Dim SharepointAddress As String Dim LocalAddress As String Dim objNet As Object Dim FS As Object ' Where you will enter Sharepoint location path SharepointAddress = "\\sharepoint path to document ...
  • 161
7 votes
Accepted

Link on wiki page to Excel document that opens in Excel Online

Append Web=1 to the url to instruct it where to open. Of course you have to have all the prereqs in place. /PWA/ProjectBICenter/Documents/AllXLDashboards.xlsx?Web=1 Opens it in Excel Services web ...
  • 1,264
6 votes

Generating excel file from SharePoint list

Use export to excel option. The list will be downloaded as an excel file. Open the file and provide your sharepoint credentials. You are good to go.
5 votes
Accepted

Can I edit a workbook using Excel Services?

From the Excel Web Access Web Part it's not possible to edit the workbook in such a way that you save content. Excel Web Access is a Web Part. It can display all or part of an Excel workbook, and ...
  • 25.4k
5 votes
Accepted

How to Export a Document Library to Excel from SharePoint 2010 using a custom button?

You mean like using a link? Such as this one: {Site URL}/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={List GUID}&View={View GUID}&CacheControl=1 from the post Create Link ...
  • 25.4k
5 votes

Ping from SharePoint list

I don't think this is a good use case for SharePoint. You're talking about running a "ping" from a web page but JavaScript running in a web page cannot do this - it only speaks HTTP. So you can issue ...
  • 7,818
5 votes
Accepted

SharePoint 2013 list does not export all data to Excel

Can you check if there is filter applied on the view from where you are exporting the excel? Try opening allitems.aspx (hope this view is not filtered) else you can create brand new view (without any ...
  • 1,041
5 votes
Accepted

Is there a shorthand way to save a sharepoint list as csv

As a short answer: No. There is no such parameter to export a list or Library to Excel / CSV from URL. Behind clicking on Export List to Excel from the above ribbon, you will get a URL like http://...
4 votes
Accepted

Using firefox to edit office documents inside my document library

The SharePoint / Office integration works best with Internet Explorer because the ActiveX that is required by many SharePoint components only runs in IE. Other browsers use different APIs. If you want ...
  • 8,787
4 votes
Accepted

Excel files always open in browser

Is this behavior for all users or only few and what about browser? In the real world scenario it should work, just make sure the Enable Client Integration at web app level. Central Administration > ...
  • 56.8k
4 votes

Publish and Synchronize Excel 2013 as Sharepoint List

Yes, You can do it.But for a two-way synchronization you have to download a free Add-In from Microsoft. With this tool you have to create a list in Excel, publish it to a SharePoint list and ...
  • 56.8k
4 votes
Accepted

How to save a list in a csv file via Powershell

PowerShell for SharePoint Online has really limited capabilities at the moment. There is no one liner to automate this task. But you can use CSOM inside your scripts. [System.Reflection.Assembly]::...
  • 1,924
4 votes

Programmatically read Excel file in SharePoint 2013 sandbox solution gives permission error

APPROACH 1 First add reference of two COM components. Microsoft Office Object Library Microsoft Excel Object Library excel = new ApplicationClass(); excel.Visible = false; string workbookPath = url;...
4 votes
Accepted

Excel file corrupted after uploading to Sharepoint with Python

Figured out the problem with my original code: needed to provide data kwarg and NOT files kwarg: import requests from requests_ntlm import HttpNtlmAuth session = requests.Session() session.auth = ...
4 votes
Accepted

Import/Copy/Paste Data from Excel into Existing SharePoint List

The key points are recognizing the column types and formatting the data appropriately in Excel before the attempting the import. Certain column types are not able to be imported in this way, such as ...
  • 245
4 votes
Accepted

Browser freezing when pasting large data?

I tried to do the same as you (1000+ rows) and the behavior of the browser was exactly the same. After reading more carefully the documentation Software boundaries and limits for SharePoint 2013 I ...
3 votes

Export Survey Results to Excel option not in Action Menu

None of the above should be necessary. The "Action" options are dependent on the view used. Open the "Overview" view, click "Actions" and the export option magically appears. There's no way anyone ...
  • 569
3 votes

Error when copying an empty choice field from Excel into a SharePoint 2013 Datasheet View

In this kind of situations, I modify the column and make it allow fill in choices. Then I upload the data, which will not fail, and then change the allow fill in choices option back to No.
3 votes

Automatically Import Excel Data to SharePoint List

My solution was this: http://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 ...
  • 121
3 votes
Accepted

help Column formula in sharepoint list

=IF( OR(INT(A)+INT(B)+INT(C) = 3, INT(A)+INT(B)+INT(C) = 0), "Accepted", "Not Accepted" ) This should work. FYI: The formula's used by calculated columns are Excel formula's and you can open a ...
3 votes
Accepted

Cannot find (Excel Services Application & Visio Graphics Service ) inside the Service Application Menu

Looks Like you installed the SharePoint 2013 Standard versions, All the services apps you trying to create are part of Enterprise License. Check this link for standard vs Enterprise Comparison Now ...
  • 56.8k
3 votes
Accepted

SharePoint Exports to Excel, can't I get directly in .xlsx file?

After you click on Export to Excel. Click on Open instead of save. The list would open in Excel. Then just do a Save As from excel File menu.
3 votes

How to import MS Excel data into an exisiting SharePoint List?

You can open the list in datasheet view (or create a datasheet view) and just copy & paste your excel sheet rows into the list. Just be careful that the columns are in the same order as in your ...
  • 1,224
3 votes

PowerShell script to download SharePoint attachments (Excel) with certain worksheet name

Here you go. If you have questions about what the script actually does, just add them as comments. Obviously you would need to tweak it for your uses. It would be better to use variables for the site ...
3 votes

Force a document to open in the application and not the web app?

You can go to Library Settings -> Advanced Settings -> Check "Open in the client application" Edit: This opens all the documents in client application.
  • 1,119
3 votes

how to export BI report to excel

I’m not sure an Anonymous user have the permission to actually read the data that generates the dashboard. Viewing the dashboard is different than accessing the raw data, and the little SharePoint ...
  • 25.4k
3 votes
Accepted

Import Spreadsheet with field name listed vertically/per row

SharePoint won't be able to create a list from a spreadsheet in that format. Nor will you be able to copy and paste it into quick edit mode. (Theoretically you would be able to copy and paste it, but ...
  • 9,551
3 votes

Unable to refresh data in Excel Online connected using Power Query

Clearest answer I've found to this is here: SharePoint doesn't support refreshing Power Query data sources at the present time. Although it's true that SharePoint and SharePoint Online don't ...
  • 235
3 votes

Not clickable cells with excel web part

Yes there is. Open your spreadsheet in Excel client application. Select the cells you want to disable from clicking. Go to the review tab, and select protect sheet. Uncheck the "Select locked cells" ...
  • 25.4k

Only top scored, non community-wiki answers of a minimum length are eligible