Slicer Not Recognizing Pivot Table

[BigBadBill]

Well, I'm 90% fixed with my other problem and something tells me this is simple so I'm going to give it a shot. I need to create a simple slicer for a pivot table. I am creating the pivot table via a macro (below). Even though Excel clearly shows a happy pivot table, the slicer stays gray until I just select a blank cell (which is useless for creating a slicer).

So, I've attached the file, the code I'm using for the slicer and the code I'm using for the pivot table. Please let me know what obvious thing I've missed.


Test.xlsx

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[JosephP]

your pivot table is an excel 2000 version because you used the wizard so you can't use a slicer with it-you should use the pivotcache's createpivottable method

[BigBadBill]

Thanks. I will try that.

[BigBadBill]

Okay, I feel like I'm really close here. 3 different XL books say that I got this right but I keep getting a syntax error on the section marked in red. Any ideas why this is tanking?

Please Login or Register  to view this content.

[JosephP]

you're missing a comma and a line continuation character

Please Login or Register  to view this content.

[BigBadBill]

Actually, I got the same error message with the comma and line continuation. I found some alternate language and it works fine. Nevertheless, thanks for the help.

Please Login or Register  to view this content.