ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Publishing an autoupdating Excel Worksheet (https://www.excelbanter.com/excel-programming/305346-publishing-autoupdating-excel-worksheet.html)

Robert Mineman

Publishing an autoupdating Excel Worksheet
 

Is it possible to publish an Excel worksheet that has SQL
queries embedded in it using the "Data - Get External
Data" feature, so that the resulting HTML page also auto
updates every minute?

Currently I have several users who would like access to
some "real time" statistics that I have available in
spreadsheets.

My current efforts to publish these spreadsheets to web
haven't proved usefull as the spreadsheets, once
published, are static and do not update every minute like
the Excel spreadsheet does.

Any assistance would be greatly appreciated.

Robert Minneman


All times are GMT +1. The time now is 08:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com