Home > IT Answers > Development > Pivot table automatic update in Excel 2010
Eogy
60 pts.
 Pivot table automatic update in Excel 2010
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
ASKED: December 31, 2010  12:31 AM
UPDATED: January 12, 2011  7:15 AM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  January 12, 2011  7:15 am  by  Subhendu Sen   22,035 pts.
All Answer Wiki Contributors:  Subhendu Sen   22,035 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Pivot table ‘properties’ in 2010? Where?

MrGamgod
 10 pts.