2
I have an Excel Workbook that gets data from an API using PowerQuery, to populate the tables. There are also filters and slicers in the workbook.
Is it possible to publish this workbook to SharePoint or another web site and have that data "refreshable" on that site without republishing?
I am able to publish as a web page but the data is static.
I am currently using Excel 2010, but have access to all other versions.
AFAIK this is not supported. – Mike Honey – 2014-09-24T02:43:08.580
I don't know of a means to do so specifically, but there might be a means of using ActiveX Data Objects to query your workbook as if it were a database. You won't get the nice filters and slices, though.
Alternatively, you could write a script and connect it to a scheduled task to periodically publish your workbook as a static web page. – variant – 2014-10-15T21:37:08.507