Hello, 

I have created a excel spreadsheet with 5 columns and LOTS of rows. I have filtered my data by my column B, before I created the pivot table I deleted the filter. I selected all of columns A,B,C,D & E (meaning all rows under these columns, including new data to come) and created 3 separate pivot table's, that are all pulling data from there. Everything works fine the first time, however when I add more data to the 1st sheet and then go to my pivot tables and refresh them. My first 2 tables & charts update correctly, but the last chart is not pulling that data or its not updating. If I delete only that table and redo it basically, it shows the correct data. I have tried to read and google for answer but couldn't find anything helpful. I have changed the pivot table name and made sure the data source is selecting all new and all to come data. Nothing is working. I can email you a copy of what I'm working on if that would help. 

Just to test at the end of the 1st spreadsheet I added TEST1 to see if I could see it refresh and show but it didn't work. :( 

Hi,

May I know what Excel version are you using? 2010, 2013 or other version? Theres one things I will need your help to understand, what do you mean by new data to come? Do you mind send me the spreadsheet you are working on to me through: ibsofc@microsoft.com, so I can take a look from my side.

I created 3 Pivot Table from one spreadsheet with Excel 2013, added new data to the sheet, after I refreshed the first Pivot table the others two refreshed automatically. So it will be very helpful, if you can share the sample of your spreadsheet. Thank you.