Here Are the Files You Need
This module contains the dashboard and the Access database:
This module contains the resulting dashboard, the Access database and the first version of the tutorial, created using Excel 2003.
This is the Excel dashboard:Download the Excel Dashboard
This is the Access Database:Download the Access Database
This is the Access Database for Access 2002-2003:Download the Access 2003 Database
If you don’t have Access, instead of a blank sheet start with this one: Data for Lookup Tutorial. This is just the data. Please watch the videos about connecting to Access, because you still need to add named ranges and formulas.
I’m trying to download the Excel Dashboard file and the Data for Lookup Tutorial file and I’ve been unable to open either of them once downloaded. I keep getting the error “The file might have been damaged or modified from its original format”. Are these files compatible with Excel 2010? Any ideas why they’re not working?
Emily: I have no problems in downloading and opening them in Excel 2007. I’ll check with Excel 2010 asap.