Export Excel Lists To SharePoint And Connect Them

Подписаться 27 тыс.

Просмотров 107 тыс.

50% 1

The CEO of kalmstrom.com Business Solutions shows how to export two Excel lists in Excel 2010 to a SharePoint site. He also explains how to connect the two lists in SharePoint. So that you can get info from one list by clicking in the other one. His example is to click on a country in a SharePoint list and see all customers from that country on the same SharePoint page. For more info and many other tips, refer to www.kalmstrom.c...

Опубликовано:

30 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 24

@abhaygore6770 5 лет назад

nice video , but how do I automate this excel upload into sharepoint zero touch

5 лет назад

I would recommend using PowerShell for that. That is another series of videos coming soon I hope.

@shuklaanvesh3627 3 года назад

Export to excel option not showing in SharePoint list where I can enable it in SharePoint

@avecNava 5 лет назад

Thanks loads. Very well and detailed video. I wanted to know if there's any trick to remove the select icon (double arrow heads) and integrate the select feature when Country is clicked. The select row is taking space for nothing. Moreover, the icon is pretty small to find and select.

@kalmstrom 5 лет назад

Most welcome! The "simplest" way of doing that is to hide those arrows with some CSS on the page (display:none). Here is a video that will hopefully get you started on that: www.kalmstrom.com/Tips/SharePoint-Online-Course/Content-Editor-CSS.htm

@rondahiya8646 10 лет назад

Thanks for this tutorial...its very helpful.. But i am facing a problem, when i click on finish button in export window, its throwing an error that it cannot be done. can you please help me as i am very keen to learn sharepoint and excel data sharing.

@dallarmellinamarc585 4 года назад

Long time later but have you received an answer

@razorcade 6 лет назад

Curious why you didn't use a Filter Web Part to select the countries on the Customer List web part?

@kalmstrom 6 лет назад

Agreed, it is a good idea! I have another demo on that: www.kalmstrom.com/Tips/SharePoint-Online-Course/Connect-Web-Parts-Click-to-Filter.htm

@tarun4494 6 лет назад

great, its very use and help full

@VipulJainEducation 10 лет назад

Very Helpful.. :) Keep Posting

@NhungDao-DESIGNER-GRAPHICS 11 лет назад

địa chỉ khi bạn export table to sharepoint list đó bạn

@satishn4740 8 лет назад

Thats a nice demo, I would like to ask few things. using SP 2013, we can upload a new excel file but what about amending ? if new rows is been added to Excel then how the same can be pushed to SP on the same existing List. Any demo you have for that. It will be very helpful. Appreciate your help.Thanks

@kalmstrom 8 лет назад

+Crystalsanjay S You can do this in Access. Here is how you get started: www.kalmstrom.com/Tips/SharePoint-Online-Course/Import-Access.htm