This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello,
I'm becoming familiar with the data query functions on excel. I can pull data from folders on my computer, however I want to create reports that pull data from excel sheets stored on our companies SharePoint site so other staff members can easily refresh the data every week. I tried using 'Get Data From Web' and inputting the url for our home site, but all of the authentication options say 'We couldn't authenticate with the credentials provided. Please try again.' I have access to our site and the documents in question, but I can't get past this screen!
Can anyone help me figure out how I can pull data from multiple excel sheets stored on our SharePoint site? The subscription product I'm using is 'Microsoft 365 Apps for buisness'.
Thanks!
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Try From File > From SharePoint Folder
Enter the Site URL
In the next screen choose Organization Account and click Sign-in. Provide your credentials.