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