Error message when using access as external data for excel pivot tables.
Excell 2007 Access 97. Error is "data could not be
retrieved from the database." Dont know how to get rid of it and refresh my
pivot table. Other tables in the same Database are available. The main one
isn't.