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)
According to this:
"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?
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
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.
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
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.
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