Hi everyone i have created a a pivot table and i just wonder whether pivot table will be auto updated for example when i update by adding extra data the pivot table should be automatically updated without selecting the range manually any idea how to do that ?