I have imported data from a query in an Access database using VB code. I can create pivot tables and charts from the data but when I double click a cell in the pivot table and a new sheet comes up with the filtered data, I no longer have the ability to further filter the data. Usually the new sheet with filtered data hase a top row with all the headings, and all the headings have a drop down arrow that can be used to filter the data. I'm not getting the drop downs menus. Also, the new sheet with the filtered data usually is reformatted and alternates line colors and just makes the filtered data look nicer and easier to read. It's not doing that either. Does anyone know why or what I can do to get these things to show up?