Pivote table adding Fileds

[jena]

Dear All Happy new year
I had creat pivote table on table that was exported from Access (it was
exported from query that based on relation beteen tabled ) ,if i make
refreshing data on the same filds the new data will be refrexhed withot
any problem , but when i add new filds in the query and exported again
(with the same name and the same orginal fields but with one or two
more additional fileds ) if i make refresh he can get and match the old
filds but not the new filds , so i can not add this filds to the pivote
table unless i restart the pivote table from the start ,
MY Question is , is there any way i can add these new filds to my
prevouse pivote table withpout restart it from the biging ( i mean to
start making this pivote from zero)

Please Help me

Thanks

Jena

 

[Debra Dalgleish]

Right-click a cell in the pivot table, and choose PivotTable Wizard
Click the Back button
Click the Get Data button
In the Query Wizard, click the + beside the query that you used.
Select the new fields in the list, and click the > button, to move them
to the list at the right.
Click Next, three times, then click Finish.

 

[jena]

Dear Debra Dalgleish

Thank you a lot that really work and help me strongly in my work ,it
save me time thanks again

 

[jena]

Dear Debra Dalgleish

Thank you a lot that really work and help me strongly in my work ,it
save me time thanks again

 

[Debra Dalgleish]

You're welcome! Thanks for letting me know that it worked.