I am Having difficulties finding how to automate a Pivot Table

[jdelorme]

Hello

Here is the situation.
I have a flat table created from a macro that merges 2 other table (one contains the assignments from a resource, and the other I have the capacity of work for the resource)

Once that table is generated, I have a PivotTable and a Pivot Chart attached to it.

Here is what I want to do.

I want the Pivot Table and Chart to be regenerated automatically based on what the source table (the one I create with a Macro) ... but the table does not have the same number of columns or lines each time I run it.

I found on the forums this sentence :

Please Login or Register  to view this content.

It does not seem to work....

What should be the syntax? I read that I only need to update the cache once and it will update both the pivot table and the pivot chart because they have the same source.

Can someone help me...

By the way I run Excel 2013

Thanks
Jean

Moderator Request: Please use code tags as shown when displaying VBA

[jdelorme]

heu ok
But how do I do that?