Read the DW2 link in my signature, about "Creating a simple data app"
Get it all working with a DATABASE first (mak it easy on yourself; walk before you run)
Then go to ConnectionStrings.com and work out what conn str you need to use in place of the database, with the Microsoft Jet driver, to use excel as the data source, rather than access
Then consider that you should really be using Access for this, not Excel