B
Brian M
I have a spreadsheet that pulls a data from the web
through a data query. I have another spreadsheet that
does a couple lookups on the query and displays the
results. That second sheet is then published as a web
page upon saving it. Is there a way that I can leave
that workbook open and have Excel autosave and publish
every 10 minutes. Right now I it will auto refresh from
the web, but I have to hit the save but to get it to save
and publish. All help and ideas would e greatly
appreciated.
Thanks,
Brian
through a data query. I have another spreadsheet that
does a couple lookups on the query and displays the
results. That second sheet is then published as a web
page upon saving it. Is there a way that I can leave
that workbook open and have Excel autosave and publish
every 10 minutes. Right now I it will auto refresh from
the web, but I have to hit the save but to get it to save
and publish. All help and ideas would e greatly
appreciated.
Thanks,
Brian