How do you update a pivot table?



How do you update a pivot table?..

Answer / Girish Chandra Asrekar

To update a Pivot Table in Excel, make sure your raw data has changed. Then, right-click on the PivotTable and click on Refresh. Alternatively, you can press Alt + F5 to refresh all PivotTables within the active workbook. If you have linked your PivotTable to an external data source, ensure the connection is still valid before refreshing.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Excel Microsoft Interview Questions

How many sheets can you have in excel?

1 Answers  


How do I fill a cell in excel based on another cell?

1 Answers  


How do you insert a table in excel?

1 Answers  


How do I restore microsoft excel?

1 Answers  


What is an append query?

1 Answers  


How do you keep a cell constant in an excel formula?

1 Answers  


Is csv an excel format?

1 Answers  


How many rows are there in excel 2007?

1 Answers  


What are the functions of excel?

1 Answers  


How do I do a lookup table in excel?

1 Answers  


What is absolute in excel?

1 Answers  


How do I combine first and last name in excel?

1 Answers  


Categories