Share via

Excel get Data from other Excel file

Shailesh P Mehta 41 Reputation points
2020-07-22T17:00:54.547+00:00

I am trying to Pull Data in Excel file saved on my Desktop, from another file saved on Team/SharePoint site.
It creates an error message Details: "Access to the resource is forbidden."

I can connect to any other Excel file and get Data from another Excel file, saved on any other shared Hard Drives, but can not connect to file saved on SharePoint site

Microsoft 365 and Office Excel For business Windows
0 comments
Accepted answer
  1. Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff
    2020-07-23T07:34:28.603+00:00

    How did you get Data from SharePoint?
    If you're using Power Query to create the connection, go to Data- Get Data- Data source Settings:

    13377-196.png

    Select Edit Permissions...- Change Type to Organization Account and sign in:

    13378-198.png

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Rachel R 1 Reputation point
    2020-07-22T17:12:50.573+00:00

    is it an enterprise sharepoint location? try using login details you use in your organization.

    0 comments

Your answer

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