Pivot Table not Pulling Data

%3CLINGO-SUB%20id%3D%22lingo-sub-278196%22%20slang%3D%22en-US%22%3EPivot%20Table%20not%20Pulling%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-278196%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20had%20this%20problem%20several%20times%20and%20have%20been%20able%20to%20fix%20it%20by%20deleting%20and%20recreating%20a%20new%20Pivot%20Table%20but%20this%20time%20it%20is%20failing%20to%20input%20the%20data%20that%20I%20changed%20today%20into%20the%20table.%20I%20am%20not%20sure%20why%20this%20is%20happening%20but%20even%20when%20I%20go%20into%20the%20filters%2C%20today's%20date%2C%20which%20is%20the%20data%20I%20am%20looking%20for%2C%20is%20not%20even%20showing%20up%20as%20a%20filter.%20Please%20help.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-278196%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-278409%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%20not%20Pulling%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-278409%22%20slang%3D%22en-US%22%3E%3CP%3Ewhen%20you%20need%20to%20update%20the%20pivot%20table%20to%20reflect%20the%20latest%20changes%2C%20select%20a%20cell%20within%20pivot%20table.%20From%20PivoteTable%20Tools--%26gt%3BOptions%20selext%20%22Refresh%22--%26gt%3B%22Refresh%20All%22%20on%20%22DATA%22%20tag.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Deleted
Not applicable

I have had this problem several times and have been able to fix it by deleting and recreating a new Pivot Table but this time it is failing to input the data that I changed today into the table. I am not sure why this is happening but even when I go into the filters, today's date, which is the data I am looking for, is not even showing up as a filter. Please help. 

1 Reply
Highlighted

when you need to update the pivot table to reflect the latest changes, select a cell within pivot table. From PivoteTable Tools-->Options selext "Refresh"-->"Refresh All" on "DATA" tag.