Update htm page with xml

R

razorx8

I have an excel sheet that imports data from an XML document. This XML
doc updates every hour.

Excel takes the information from the XML and makes charts. I want to
publish the Excel document as an htm file and put it on a web server so
I can view the charts online.

My question is...how do I get the htm file and graphs to update with
the xml file? The numbers constantly change, so after an hour the
graphs and stats are not accurate. How do I get them to sync to the
XML?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Integrating information from Word to Excel (not mail merge) 1
Connection/Refresh Control unavailable for imported XML data 0
Excel XML - on a mac? 0
Help Creating XML File from Spreadsheet 1
A Look Into The Good and Bad Points of XML 0
Creating XML file for Excel 1
Transforming XML to HTM with VBA 0
Save Excel File As XML 1

Top