Good day everyone,
I am using Excel 2010 and have created a named Table off of which I have made a pivot table and a chart. When I add a new line of data at the bottom of the Table, it is being added to the Table range just fine. I tested this by selecting the table range name and all the data (new line included) was automatically selected. However, that new line of data is not showing up in my pivot table or chart. I checked the data source for the pivot table and it points back to the named Table. What could be the issue?
Thank you in advance!
Seth
Bookmarks