Pivot table automatic update in Excel 2010

60 pts.
Tags:
Excel 2010
Excel Tables
Pivot tables
Windows XP Professional
How to make my pivot table automaticly updated if I edit, delete, append the source data?

Software/Hardware used:
Microsoft Excel 2010, Windows XP professional version 2002 service pack 3

Answer Wiki

Thanks. We'll let you know when a new response is added.

In PivotTable Properties > PivotTable and on PivotTable tool bar u can change the automatic update property in there. It is also possible to Auto-Refresh if the table is based on external data.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • MrGamgod
    Pivot table 'properties' in 2010? Where?
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following