Slicer cache causing issues in VBA

Hi,

I am trying to get code to create a pivot table and slicer out of the data on each sheet.

I started by recording a macro then copying it into VBA and copying the code across each sheet for every month changing the names of the month.

The Jul and Aug sheets seem to work when I run the Step 4 - Apply Pivot Table command but when I run the Sept sheet with the same data I get

Run Time error '1004'
The item with the specified name wasn't found.

Please Login or Register  to view this content.

It is a work in progress and I'm not sure I'm going about it the right way so any recommendations would be appreciated.

Thanks
Tom

Hiii,
Please go through following link
https://support.microsoft.com/en-us/kb/940166

Hi Mangesh.mehendale,

I followed the instructions on the link you provided and it puts the pivot table on another sheet. Also, it did not rectify the initial problem.

Humdingaling,

Thanks so much. Your code works like a gem. I'll go back and try to work out what you did. I'm new to this game as you can probably tell.

Cheers
Tom

Hi Humdigaling,

Thanks very much for your feedback. Much appreciated.