I am new to pivots but can see how quick and useful they can be.
I have a list of of events on my spreadsheet that so far go down to row 146. These events happen continuously so one of my column headers is "Year" and I list what year it happened. So far I have done 2009 / 2010. Eventually I will bring it fully up to date to 2014. Once up to date, I will list new entries as they occur.
I have set up several pivot tables as a means of learning how to do pivot tables. In the drop down for Column Labels it currently has the options of 2009 / 2010 / blank. I now want to add the data for 2011 and beyond. I did the first few and then looked at the pivot tables. It did not add 2011 to the option or any of the data. Is there a way that I can get a pivot table to include data added after it is created? When I created the pivot table I didn't just select the range of cells that had data in them at that point (A2:K124) . I selected the column headers (A:K) thinking it would utomatically expand as new data was added to the selected range.
Is there a way of getting the pivot table to include new data?
Thanks for your help
Bookmarks