On the other hand, if you use a PivotTable, you need to either perform a manual refresh to display the latest version of your figures or create some VBA code to automate this process, though, in ...

You don’t need to do this for this technique to work, but you should know that you can. Figure B You can force Excel to refresh PivotTable objects when you open the workbook.