If you’ve created a pivot table and later added more data then you’ll need to expand the pivot’s data range. 

NOTE: You can change your data into an Excel Table (Hold ‘Ctrl’ key and press ‘T’) and when you add more data the Pivot range won’t require expanding (just refresh the Pivot)

 

Download my Excel file

Download here or via my OneDrive (file 00014)

 

Watch my YouTube video

 

Subscribe to my YouTube channel and learn more!

See my free templates here!

Post a comment