CODEWITHSUNDEEP
excelsharepoint
Maddy
Maddy

Reputation: 39

Connecting to SharePoint list from Excel

I have used data--> other sources-->web for connection

enter image description here

enter image description here

I see document and table on the left hand side. When I click on the table I see 30 rows on the right hand side. These 30rows are first page. In the SharePoint there are few more pages of this list. It just loaded first page rows in table.

I am connecting to a SharePoint path from Excel. In excel, once I created the connection. I am able to view only 30 rows of the list. 30rows exists in the first page of SharePoint.

How can we load other pages of the SharePoint list in excel.

enter image description here I am getting this message when I use the connection as SharePoint list

Upvotes: 0

Views: 46

Answers (1)

Xyza_MSFT
Xyza_MSFT

Reputation: 409

Please check the steps to connect: enter image description here

Upvotes: 0

Related Questions