Problem with Macro creating Pivot Table

on an already existing table? is there a pivot table already in place on Report 8 Pivot? if so you can just refresh the table in the macro (no create one)

Hi smls
No way to test but you can try this

Please Login or Register  to view this content.

Hi smls
Don't know...try changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

if you want to refresh a pivot table you already created, you don't need a macro-just right-click it and choose refresh. :-)
btw in your original code you have spaces in the sheet names so you have to enclose the name in single quotes, and the tabledestination argument should only be one cell.

no-I was referring to your original code

Please Login or Register  to view this content.

not a good idea to use entire columns though so I'd use

Please Login or Register  to view this content.

I prefer using variables for each step as it's easier to debug and then you can reuse the pt variable when adding all the fields and formatting the pivot table.

@ josephP,

using macros to refresh pivot tables is sometimes really very helpful. For instance if the user is altering the contents of a worksheet using a macro and another sheet feeds multiple pivot table/charts from that altered data, refreshing the pivots for them is nice. They don't know what is happening, but every time they access the sheet the tables/charts are accurate

agreed though I prefer event code for that (if I can't rely on a user to refresh a pivot normally I ain't going to rely on him pressing any other button instead!).