New answers tagged

1

With Microsoft Access you can link all 3 SharePoints lists, built a Query and Export whatever you want


0

There is not direct out of the box way to do this. One option is Export first list to Excel Now change the connection name to List1 Export second list to Excel. Here choose new WorkSheet instead of WorkBook Change the connection name to List2 Export third list to Excel and choose new WorkSheet Change the connection name to List3 Now you can use Excel ...


0

This isn't an excel issue. Person or group fields can't be retrieved using a lookup. You can get around this by using code, or by making a string copy of the owner field by running a workflow each time the item is changed, and the string can be retrieved using a lookup.


-1

there are couple of ways to achieve this and already answered on technet please refer http://social.technet.microsoft.com/Forums/sharepoint/en-US/396fb71d-5fda-4fe1-9d39-4332944bead1/import-excel-data-into-sharepoint-calendar http://social.technet.microsoft.com/Forums/sharepoint/en-US/ddc20756-a191-434e-866b-97523b405a82/import-excel-data-into-sharepoint-...


0

I don't think so. In theory, you could map the SharePoint library as a drive, and then create symlinks to the new file location. That would be quite a bit to configure and manage, and prone to failure with connectivity issues. That solution would probably not work if you are talking about internal links between Excel workbooks/files. There are 3rd ...


1

There are lots of reasons mentioned in below article by which your query will not work & will not fetch the data from SharePoint List columns. One of the example given in below article is Well if you know SharePoint lists, you know you can change field display names, and many other things in List Settings. In the screen shot above, the “...


0

Try this endpoint URL to get the Multi Choice Lookup field data: var url = "/_api/Web/Lists/GetByTitle('Product Type')/items?$select=Owner/Title&$expand=Owner/ID"; To retrieve the data of each values of multiple field use below code, var items = data.d.results; var owners; for (var i = 0; i < items.length; i++) { owners = items[i].Owner....


0

My answer is based on my assumptions that you're using a template which is uploaded to the Content Type, and that the Content Type is used on the document library where you see this error. In order to get the Site Columns connected to the SharePoint document library, you have to upload your template to the document library. The fields in the template ...


0

For anyone who may stumble across this... I had to create several macros in excel and got them to run when loading excel which meant the end user never saw them!


1

For those who may stumble across this - It's not possible Pre 2013 The link I followed to complete this is as follows: https://blogs.technet.microsoft.com/excel_services__powerpivot_for_sharepoint_support_blog/2015/07/28/excel-services-consuming-a-sharepoint-list-using-the-listdata-svc/ Thanks anyway guys


2

Go to your Library Settings -> Advanced Settings For 'Opening Documents in the Browser' choose 'Open in the client application'


0

I tried and the below URL made dynamically can help you to get excel imported. https://test.sharepoint.com/_vti_bin/owssvr.dll?CS=65001&Using=_layouts/15/query.iqy&List={F3A732BB-355B-42BE-A7D0-08994B5CB0E9}&View={FAD0BA53-B5A5-4E52-8A76-5AED6C2615F8}&RootFolder=/Lists/List A&CacheControl=1 But make sure to have SharePoint ...


0

List views can be export to excel by passing List GUID & List View GUID with the URL as mentioned below : https://<siteurl>/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={<List GUID>}&View={<List View GUID>}&CacheControl=1 You can easily give this url in a button click in your page. Make sure that the user ...


1

If you need to ask questions and have user responses in SharePoint, I would recommend to use Survey list. Here are few references: https://support.office.com/en-us/article/Create-a-survey-ea52a787-822e-4f7e-b5ed-77bb14df3aba


0

A workflow doesn't sound like the best tool to achieve what you're attempting, in my opinion. I would embed some javascript in the form template to dynamically hide/show options based upon user input. To my knowledge, a workflow cannot manipulate a live form (one that a user is inputting data into).


1

Hey I have got the same requirement to work with and I was able to accomplish this task so here I am sharing my approach. I created a Excel file using SPFile object available in sp.js var fileCreation = new SP.FileCreationInformation(); var d = new Date() var utc = d.toJSON().slice(0, 10) + "-" + d.getHours() + "-" + d....


0

create an Excel Services Application and start the service on at least one machine in the farm.


-1

create an Excel Services Application and start the service on at least one machine in the farm.



Top 50 recent answers are included