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

Or you can use Sharepoint list synchronizer that will do that for you in a single click: SharePoint List Synchronizer I think there is a free version that you can try out.


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

Why don't you make another personal view with all columns?


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


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

Here is a trick I've tried in your situation: Change your view in SharePoint to only display like Maximum 1000 rows. (use the Limit in the bottom of the view definition screen) Attempt again to export to Excel - this should work without issues (if it doesn't the problem lies elsewhere in your SharePoint and then you should have a look in ULS) Change back ...


4

We had to open a case with Microsoft about this same issue. We literally tried every solution suggested in this thread and many others (IE settings, Office Trust Center settings, removing cache directories, etc, etc). It turned out that a pre-release version of Office was installed on the affected machines. The pre-release version (found in Control Panel -> ...


4

There can be many approaches for this particular job (I bank on your statement that you can do this with C#) - Write a custom workflow, when a document is uploaded to a particular document library the workflow triggers Write a custom web part with upload control, when user upload the document you can do all the calculation and accomplish the job Write an ...


4

Ziba, OpenXML SDK is what you are looking for, OpenXML SDK can help you edit and create word, excel and other documents programmatically and it works great with SharePoint! Following links can help you: Modifying Open XML Documents using the SharePoint Object Model SharePoint and OpenXML ERIC White has written many articles on SharePoint with OpenXML: ...


4

Well, I searched some more and found the solution (thanks to SunnyLowe) The real problem here is Internet Explorer (IE). In IE, from the File menu or Tools Icon, select Internet Options|Security Tab In the "Select a zone to view... ", click Trusted Sites so it is highlighted. Then click Sites to add the site to your trusted sites list. Tab. (This was ...


4

You can configure the default-open behavior of browser enabled documents in the list settings. See http://technet.microsoft.com/en-us/library/ee837425(v=office.14).aspx If you don't want miss excel service feature, you might also think of providing a dedicated page where a web part displays your library and another web part (for example a content editor) ...


4

Which Internet Explorer do you use? Be sure to use the 32-bit version instead of the 64-bit. That solved the problem for my user.


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


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