Hello, I'm working with Excel and Project.
I'm working with excel to get all the resumed information of our projects from Project online.
I'm trying to get the data in excel from a sharepoint list (My organization pwa list).
However when I put the sharepoint link in excel I see a lot of different lists from pwa but I cannot find the list I see in Project Center where we have a list of all of our projects with some level of detail about owner, % completed, etc.
The list I'm trying to get is in myorganization.sharepoint.com/sites/pwa/Projects.aspx
How can i get that data and query in excel?