Display live(ish) excel data in webpage

Apeman

New Member
Joined
Nov 29, 2018
Messages
7
Hi

I have created some reports in excel and have various pivots and graphs that I can view/refresh. What I would ultimately like to do is have the contents of the excel page displayed via a web browser so this can be seen by people across the business with out them using the excel spreadsheet, I would also like the contents to be displayed on a wall screen. My spreadsheet uses an ODBC link to some data tables that our management system writes to.
I have managed to make it work manually by publishing as a web page and set to republish every time workbook is saved, I have used an auto refresh plug-in for chrome, i just need it automating! I am thinking that I need an auto refresh function adding, to refresh the data tables and a timed auto-save function, which will in turn refresh and save the workbook every minute (or two).

I am a bit of a VBA noob, and most of the stuff I know I have picked up from forums like this, so I am sure this is pretty simple, but I simply just don't know how to do it!

Any help on this would be most appreciated. Thanks in advance
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Forum statistics

Threads
1,141,051
Messages
5,703,967
Members
421,321
Latest member
blusky4

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top