Need Help With PivotTable

[Joefried]

Hi There

thank you for looking at my question

i created a Pivot table out of an invoice but would like if i replace the DATA from the invoice tab the pivot table should update it self?

Please help me on how this could be done i'm using 2007

thanks for trying

 

[Joefried]

ok so finally it started to work but now its unchecking my pivot table fields

 

[Cyclops755]

Do you mean that it's resetting all the data filters in your PVT? I've never seen this happen, so I'm not sure why that would occur.... What version of Excel are you using?

One other possible thing to try: Record a small macro of you refreshing the table using the button in the ribbon toolbar, then set that macro to run every time the sheet is opened. The code for that would look like:

Private Sub Worksheet_Activate ()

macro1

End Sub

Replace the current code with that

 

[Joefried]

wow thank you it really worked
yo're a life saver