Share via

No SharePoint data source found on excel

sns 9,251 Reputation points
2021-08-16T03:38:11.483+00:00

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.

Microsoft 365 and Office | SharePoint | For business | Windows
0 comments
Answer accepted by question author
  1. JoyZ 18,126 Reputation points
    2021-08-16T07:59:48.207+00:00

    @sns ,

    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.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.