ExcelBanter - Pivot Table and SQL Database

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot Table and SQL Database (https://www.excelbanter.com/excel-discussion-misc-queries/219252-pivot-table-sql-database.html)

Erika

Pivot Table and SQL Database

I have a SQL database that I am trying to get to connect to a pivot table. I
have the connection working I can pull the information into a Pivot table
however the drop down boxes on the fields do not populate. They are empty.

All times are GMT +1. The time now is 01:45 AM.