none
In SharePoint 2016, Excel refresh issue - A connection to the SharePoint site cannot be established RRS feed

  • Question

  • In SharePoint 2016, unable to refresh the excel file

    A connection to the SharePoint site cannot be established.To synchronize or refresh your table, you must be able to connect to the SharePoint site

    Tuesday, June 5, 2018 7:01 PM

Answers

  • The excel is  stored in local machine of the user. After the migration, data connection got changed. Hence after the updating the data connection in excel, SharePoint list data started populating.
    • Marked as answer by ghsajith Wednesday, June 6, 2018 6:58 PM
    Wednesday, June 6, 2018 6:58 PM

All replies

  • Hi ghsajith,

    Do you open the excel with excel online?

    Is there some data collection from SharePoint site in the excel file?

    Best Regards,

    Lisa Chen


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.


    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Wednesday, June 6, 2018 11:03 AM
    Moderator
  • The excel is  stored in local machine of the user. After the migration, data connection got changed. Hence after the updating the data connection in excel, SharePoint list data started populating.
    • Marked as answer by ghsajith Wednesday, June 6, 2018 6:58 PM
    Wednesday, June 6, 2018 6:58 PM
  • Did you ever figure out how to correct this?
    Friday, October 18, 2019 12:54 PM
  • Update the data source in the excel.
    Monday, October 28, 2019 7:12 AM