5 ms·
You can do some of these tricks with Excel 2016 or later and SharePoint Enterprise or Office 365 -- which many corporations already have. You can embed an auto
by danny8000 7y ago
You can do some of these tricks with Excel 2016 or later and SharePoint Enterprise or Office 365 -- which many corporations already have.
You can embed an auto-updating Excel file in a SharePoint webpage using a "webpart" that renders as HTML. (Microsoft is getting away from web-rendering Excel with Silverlight,and allowing more functionality without the need for a browser plug-in.)
The trick is to setup the Excel data connection using the "Get External Data" -> "From Other Sources" -> "OData Data Feed" and not use the "Data Connections / Microsoft Query" method. Note: Microsoft Query connections won't update server side, the Excel file needs to be opened, data connections refreshed, and re-saved.
It does require a bit of Excel expertise to setup, but there is no need to create a Java application to get it to run.
- oneplane 7y agoI'd rather have my Java expertise than Excel expertise.