If you are working through the example, "Building a Pivot Table with Microsoft Access Data" (starts on pg 180 in Pivot Table Data Crunching) you will run into issues with the Access DB on the Mr. Excel site.
If you download the Access DB from the Mr Excel Site http://www.mrexcel.com/PT2007Chap7DB.zip the Sales_by_Employee query will not be displayed in the Select Table dialog box after you click the "From Access" button in the Excel Ribbon.
The Sales_by_Employee query in the access DB requires parameters and hence will not display as a "view" in the "Select Table" dialog.
To fix this issue, you will need to go Access DB and create a new Sales_by_Employee query that does not require any parameters.
Please fix the Access DB Mr. Excel and re-post to your site.
Thx.
If you download the Access DB from the Mr Excel Site http://www.mrexcel.com/PT2007Chap7DB.zip the Sales_by_Employee query will not be displayed in the Select Table dialog box after you click the "From Access" button in the Excel Ribbon.
The Sales_by_Employee query in the access DB requires parameters and hence will not display as a "view" in the "Select Table" dialog.
To fix this issue, you will need to go Access DB and create a new Sales_by_Employee query that does not require any parameters.
Please fix the Access DB Mr. Excel and re-post to your site.
Thx.
