This older blog post has just been updated to include auto-refresh time, and other information about how to change the database connection, and query properties.
Also includes a sample download for you to try.
Build a dashboard today! It's fun.
http://www.helpmasterpro....ashboard-using-Excel