Excel Web Query – What in the world is that? If you are like the other 99.9% of MS Excel users, you probably have never heard of microsoft excel web queries
To start, use Data – Import External Data – New Web Query.
Auto Refresh Feature
- Refresh every 1 minute
- Refresh data on file open
- Insert entire rows for new data, clear unused cells
- Fill down Formulas in columns adjacent to Excel data
With these settings, your Excel Sheet will automatically update the data every 1 minute from the web .