Hot answers tagged

10

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 appropriate REST link and click on Next. REST Link format to get Sp Group users: https:// Your SP2013 Site /_api/Web/SiteGroups/GetById(9)/Users 4) In Next form, ...


8

If you're trying to get cell data from Excel (or any other table source) into a SharePoint list's Checkbox column in Datasheet view, the values in each source field must be delimited with the semicolon and hash characters (;#). Each cell's data must also have a leading and trailing semicolon/hash pair. This last bit is counter any other delimiting style I've ...


8

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 library" & "\" ' Where you will enter the file path, ex: Excel file LocalAddress = "your file path" Set objNet = ...


7

The setting you want is in Excel, not in SharePoint. Excel will, by default, open documents in Protected View from potentially unsafe locations (that includes SharePoint, but doesn't include local or network drives). In Excel 2013, the option is in File > Options > Trust Center > Trust Center Settings > Protected View. You'll want to uncheck ...


7

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 page /PWA/ProjectBICenter/Documents/AllXLDashboards.xlsx?Web=0 Opens it in excel


6

You can use the Excel URL Protocol described here: http://msdn.microsoft.com/en-us/library/ms478653.aspx With it you can create your three links and generate the excels on the fly, example: http://Server_Name/[sites/][Site_Name/]_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List=GUID&View=GUID&CacheControl=1


6

In SharePoint 2010, sites can export custom list items to Excel using the Export to Excel option in the ribbon toolbar. It will export all items in that particular view in which the option is invoked. SharePoint literally is not exporting the items it creates in the query file instead, which will have the view id and helps to query the SharePoint list data ...


6

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

If you use Excel Web Access Web Part to display the chart, it has an option to auto refresh at regular interval. Check out link below for config options: http://office.microsoft.com/en-us/sharepoint-server-help/excel-web-access-web-part-custom-properties-HA010377893.aspx'


5

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 enables interaction with the workbook in a browser by using Dynamic Hierarchical Tag Markup Language (DHTML) and JavaScript. Because Excel Web Access is a Web ...


5

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 to Export Library Contents to Excel


5

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 HTTP requests but if your devices are not web servers that's not going to work for you. Consider running a scheduled job that runs on a computer in your ...


5

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 filters) and then try to export it from that view. It should bring everything to excel.


4

You mentioned, you were able to export the groups in Excel what method you use for it? Here is method I used. Navigate to the People and Groups tab under Site Settings [Site Settings > People and Groups] Copy the URL of the People and Groups page. Open up your Excel workbook, and click on the Data tab. Click "From Web" and paste the URL from the People and ...


4

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 the full functionality of Office with SharePoint you will need to use IE. IE 11 is actually not all that bad.


4

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 > Application Management > Manage Web Applications > select the web application > Click Authentication Providers > select default zone, and select Yes for "...


4

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 synchronize with it. Once you install it, then you should now see under the Design tab a SharePoint section with a button called Publish and allow sync. Please follow ...


4

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]::LoadWithPartialName('Microsoft.SharePoint.Client') | Out-Null $login = 'test@test.onmicrosoft.com' $password = ConvertTo-SecureString 'password' -AsPlainText -...


4

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; Workbook excelWorkbook = excel.Workbooks.Open(workbookPath, 0, false, 5, "", "", false, XlPlatform.xlWindows, "", true, false, 0, true, false, false); Sheets ...


4

Actually I figured out the problem I was having with the original code. I needed to provide the data kwarg and NOT the files kwarg: import requests from requests_ntlm import HttpNtlmAuth session = requests.Session() session.auth = HttpNtlmAuth('DOMAIN\\username','password', session) put_url = 'https://secure.sp.kp.org/teams/scpmgcc/complete%20care/...


4

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 the Multi-line Enhanced Text. Let me break it down for you. :) Column Types Must be formatted as follows: -COLUMN- | -FORMAT / COMMENT- Single ...


4

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 found the following row for bulk operations via user interface: The user interface allows a maximum of 100 items to be selected for bulk operations. I think ...


4

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://your site /_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={638D72C3-264C-4797-9812-67544942EFEB} This link requires at least the List ID, and ...


3

Not a hundred percent sure about this particular webpart, but most times when this type of issues occur, it is because the functionality is dependent on some Active X components to interact with your computer. Only Internet Explorer can work with Active X. For some functions, Microsoft have tried to find alternative solutions (that is probable the reason ...


3

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

Had the same problem with two user fields containing texts. Export works fine without them. And the Solution was to add additional Filter to the View! The Filter is on Date Created Field (in my case) > xx and it's set so that all the data that we were displaying before is also shown, the additional Filter does not return any less Results, so the amount of ...


3

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 would know this so this is a good example of the bad design / UX that plagues Sharepoint.


3

I've found that dates and username fields are especially susceptible to these errors. To paste a username in a field, that user has to 'exist' on that site. Just being a valid domain user is not sufficient. They must access the site at least once in order to get their userid associated with that site collection. If you enter them via the standard forms, ...


3

Maybe it's little bit too late but maybe I can help someone else.. U can use the export to spreadsheet option only on your default view of the list. (SP2013 & Online) Knowing that, you know you should now open your survey list from sharepoint designer and set one of the views as default.. Reload survey in your browser, 2-3 times (using the ctrl + f5) ...


3

I tried your issue and unable to reproduce it. I use an Enterprise E3 license and on my team site I have checked the default behaviour in advanced settings: To enable editing I need to switch from viewing to editing before start: When this is done, it works like a charm. But I don't use Power View - which I'm afraid to say isn't supported: You can only ...


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