Excel Automatically updating my pivot table

[jbasile]

Hello everyone!

I work at a retirement community and am tracking resident falls and putting the data into a pivot table to track the "frequent fallers" so after the data, I can sort the data to show me the most frequent fallers. As the days go on however, I update the list and have to recreate the pivot table to update. I am hoping that as I pass this on to my supieror, someone who does not excel in excel! it would update automatically. Can someone give me a step by step approach to make this possible. Can excel do this?

 

[Caribeiro77]

After you create your first pivot table you don´t need to be constantly creating other pivot, you just need to right-click in you first created pivot and click "Refresh",(you have to do this everytime you insert new data), that is in my opinion the major problem(if you can call it a real problem), of a pivot table, you always have to click the "Refresh" button after you insert some data...

 

[jbasile]

Thank you for your response and that does help but one more question. Let's say I have 8 pivot tables for my set of data. Is there a way to refresh every chart at once or do I need to go to each sheet and refresh them one at a time?

 

[Caribeiro77]

When you click "Refresh" in a pivot, you are in fact refreshing every pivot/chart that are related to your data..