question

sns1 avatar image
0 Votes"
sns1 asked JoyZ commented

No SharePoint data source found on excel

123444-nosharepointdatasource.pngI tried to Get the SharePoint list data to excel, however I have not noticed SharePoint data source list in the data sources list. PFA
& One more question is 2 way sync possible like if I update in excel it should reflect in SharePoint and vice-versa.

Please help me on this. Thank you.


office-sharepoint-online
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

JoyZ avatar image
0 Votes"
JoyZ answered JoyZ commented

@sns1,

Please check the office version via File>Account:

123476-image.png

Only the Microsoft 365 Apps for Enterprise supports importing data from online services:

123497-image.png
123505-image.png

More information:

https://support.microsoft.com/en-us/office/power-query-data-sources-in-excel-versions-e9332067-8e49-46fc-97ff-f2e1bfa0cb16?ui=en-US&rs=en-US&ad=US


If an Answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



image.png (12.3 KiB)
image.png (43.3 KiB)
image.png (33.2 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

HI Wang,

PFA, so am I missing enterprise license here, Please confirm
123498-capture.png


0 Votes 0 ·
capture.png (79.8 KiB)

@sns1,

Yes, your office version is a business version, not enterprise, and there is no related online service available.

0 Votes 0 ·