Forum Discussion
Excel Pivot Table
Hello!
In order to add data to your pivottable, you need to add data to the original datatable. Probably tab 1.
Hello!
In order to add data to your pivottable, you need to add data to the original datatable. Probably tab 1.
- Yes, I want to add new data, but what do I do to get the Pivot Table to re-execute to include the new data?
Hi, there,robertpaegelow
Well, we can always add data to the source table and then refresh manually the pivot table or automacally, when opening the workbook. But..
Is there a way to update data in the pivot table really dynamically, that is, right after adding or changing data in the original source table (without having to manually refresh the pivot table, or automacally, opening again the workbook)?
Thanks in advance
umbertojmf
umbertojmf & MacLingo Unfortunately there is no built-in feature that does what you want (at least what i know of). I'm pretty sure that the only way to achieve the auto-update is by using a macro.
I've found a pretty good guide, hope that this helps you in the right direction.
https://www.excelcampus.com/vba/refresh-pivot-tables-automatically/
- Thank you so much for your help!
