Refreshing Pivot table based on cell data

[boolucy1984]

I'm looking to update a pivot table based on some info in a cell but I keep getting an error message. i've used the code before and its been fine so I'm not sure whats going on.

Please Login or Register  to view this content.

[ajryan88]

Hi,

Could you please upload your workbook?

Thanks

[boolucy1984]

I've had to remove the pivot table data connection and lost some of the functionality to upload it so we've I've included a screenshot of the pivot table as well as the original layout (Pivot table is highlighted in black). Hopefully that helps!Digital Reportingv5.xlsm

[ajryan88]

I can't find that code anywhere in the attachment...

[boolucy1984]

Apologies, I'd forgotten I tried a different code. This one is the correct one.

[ajryan88]

This is virtually impossible to debug without your actual Pivot Table to test my code on, but here's my suggested code anyway...

Please Login or Register  to view this content.

Can you please do up a sample workbook if you can't upload your actual workbook, if you can't get this code to do what you want.

Thanks

[boolucy1984]

Hi

Thanks for looking into it for me, the code didn't work but the error message is because of the line pvt.pivotfields("period etc.. and is suggesting the name of the pivot field is incorrect. I believe this is because its a power pivot with consolidated data sources. Do you know how I reference this within VBA?
Thanks in advance

[ajryan88]

I'm sorry, I've never used or dealt with power pivot...it might be time for someone else to take over here unfortunately