Run time error '1004' on changing pivot table filter line of code

I am using the following code to change the open a file, changing the a pivot table filter and copy the data to my master worksheet. The problem is that is throwing an error the line of changing the filter value, marked in red in the code.
The strange thing is that I am using the exact same code for a different file and it works properly. I verified and all the variables are declared properly. The worksheets are unprotected as well.
Why is working for another file, but not this one?

Please Login or Register  to view this content.

Thank you, but I found the problem. I have some OLAP connections for th pivot tables and these haven't been refreshed, the division change failing. Strange one anyway.