Can you lock one filter in a pivot table?

[Ray707]

I had done something similar here awhile ago, but couldn't find the previous post. It was easy enough to just recreate it for you

Look at Sales All.xlsm with some made up data

It makes 3 extract WBs based on Dept page field

The extract sheet can have some formatting before saving, and you can change the file naming easily

No real error checking

Edit: I was a little terse with my variable names, so if that's a problem let me know and I'll expand

Hi Paul, thanks for this. I have a question as it doesn't appear to be working; when I click on 'split pivot table' in the sales all depts file it activates a pop up which says 'done' but no new wb's are created, should I expect the workbooks to pop up in separate windows or does it save the workbooks somewhere..?