Refresh of Exported SharePoint list keeps failing

Ruth Elliott (IE) 0 Reputation points
2024-05-23T15:08:16.03+00:00

I have a report set up in Excel that is linked to a SharePoint list and it worked fine for weeks. But recently when I now click Refresh All, I get a message saying 'a connection to the SharePoint sire cannot be established. To synchronise or refresh your table, you must be able to connect to the SharePoint site'. But I still have access to the site, and no permissions or anything has been changed in either the site or the excel so I dont know why this is happening?

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,624 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,078 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Jiajing Hua-MFST 6,915 Reputation points Microsoft Vendor
    2024-05-24T03:41:33.7166667+00:00

    Hi @Ruth Elliott (IE)

    It is a common error message, there is more than 1 factor causing this error.

    Please click "Get Data" > Data Source Settings > Data sources in current workbook > Edit Permissions > Delete > OK > OK.

    User's image

    Then back to Data source settings > Edit Permissions > Microsoft account > Sin in your account and save it. Click refresh all for a test.

    User's image

    Here is a similar thread you may also have a check:

    https://sharepoint.stackexchange.com/questions/249821/unable-to-refresh-data-in-excel-from-sharepoint


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    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 comments No comments