Litte more advanced question

C

Chad

Is it possible to have a excel sheet that auto updates from a website
whenever the website is updated?

Now I understand the excel file would have to open for the update to occur.
But the main part of this question is really broken into two parts.

1. Can you reference online data?

2. How fast can the refresh rate be on the calculations?
 
S

Shane Devenshire

Hi,

You can connect Excel to at least some web data. But I don't think Excel
can detect when the website updates. But you could set up Excel to refresh
on a regular basis.

Connect using Data, Import External Data, New Web Query

To have it automaticlly update right click the range after you imbed the
query and choose, Data Range Properties, check Refresh every and set the time.
 

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

Auto-filter Question 1
Can I use Dynamic Ranges to automate complex calculations? 5
Formatting not updating upon data connection refresh 0
Pivot Table Detail Refresh 2
Formula Calc Problem 7
Sending notifications through outlook 2
Auto sort when worksheet/book opened 4
Problem with external data web query 2

Top