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

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,671 questions
0 comments
Accepted answer
  1. Emi Zhang-MSFT 23,191 Reputation points Microsoft Vendor
    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