Hello,

I am getting the following error when running a macro to produce a pivot table:

Run-time error '440':
Method 'Add' of 'PivotCaches' failed

Does anybody know what the reason might be? Is it a memory problem?

Thanks
Rich

Code:

Please Login or Register  to view this content.