Share via

"Connected" spreadsheet doesn't refresh

Anonymous
2017-04-26T16:18:45+00:00

According to this:

https://support.office.com/en-us/article/Synchronize-a-SharePoint-list-with-a-spreadsheet-program-d4337a01-2be4-43b5-bb42-28aefe64eafd

"To see further changes made to the SharePoint list in spreadsheet program, you must manually update the data. For example in Excel 2010, in the Excel table connected to a SharePoint list, on the Design tab, in the External Table Data group, click Refresh."

My spreadsheet connection is saved in a SP location. When I open the file in Excel online and click "refresh all connections" nothing happens. The whole point of using cloud storage is to be able to work on files in the cloud. In this case, I want another user to be able to see/edit this file with the latest data from the list. Not a problem for them to update it manually - but it doesn't work.

.What am I missing? Or is this just another weakly thought through SP process?

Microsoft 365 and Office | SharePoint | For business | Windows

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.

0 comments No comments

3 answers

Sort by: Most helpful
  1. Anonymous
    2017-04-28T07:31:17+00:00

    Hi Webbrewer3,

    It is not feasible to update a SharePoint list using an Excel worksheet with Excel online. To sync a SharePoint list with Excel 2016, here is an article for your reference: Synchronize a SharePoint list with a Excel

    Your understanding is highly appreciated. 

    Regards,

    Shirley

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2017-04-27T12:03:21+00:00

    i don't think that's correct. The user "thinks" they were able to refresh data in Excel online -  but it's hard to be sure with such a  confused and poorly designed ui. Can you provide some better documentation for the online apps? What I linked to above is obviously out of date/doesn't apply to online apps.

    We're using Office 2010 now but soon will be 2016, not that that should matter.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2017-04-27T08:03:53+00:00

    Hi Webbrewers3,

    The Excel Online is unable to refresh data while the workbook is exported from SharePoint Online list. When you open such a workbook in Excel Online, you may get the notification below:

    If you click Edit in Excel Online, then you may get the notification below:

    The right way is to “edit in Excel”

    When you open the workbook in Excel client, you may get the notifications below:

    Therefore, to refresh a workbook exported from SharePoint Online list, you need to open in Excel client.

    Thanks,

    Rena

    Was this answer helpful?

    0 comments No comments