Pivot table won't refresh.

%3CLINGO-SUB%20id%3D%22lingo-sub-138629%22%20slang%3D%22en-US%22%3EPivot%20table%20won't%20refresh.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-138629%22%20slang%3D%22en-US%22%3E%3CP%20style%3D%22margin%3A%200in%200in%200pt%3B%22%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3EPivot%20table%20won%E2%80%99t%20pull%20today%E2%80%99s%20numbers%20for%20each%20adjuster%20even%20though%20the%20data%20source%20covers%20entire%20worksheet%20and%20field%20is%20set%20up%20to%20count%20per%20adjuster%20name.%3C%2FFONT%3E%26nbsp%3B%20What%20am%20I%20missing%3F%20HELP!!!%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%200in%200pt%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%200in%200pt%3B%22%3EThanks%2C%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%200in%200pt%3B%22%3EEvangeline%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-138629%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-138863%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20won't%20refresh.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-138863%22%20slang%3D%22en-US%22%3E%3CP%3EDo%20you%20have%20any%20filters%20set%20on%20your%20pivot%20table%3F%26nbsp%3B%20Sometimes%20filtered%20PTs%20don't%20recognize%20new%20items%20until%20you%20clear%20the%20filter.%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-138700%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20won't%20refresh.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-138700%22%20slang%3D%22en-US%22%3E%3CP%3EAre%20you%20sure%20that%20the%20data%20source%20has%20the%20updated%20numbers%3F%3C%2FP%3E%0A%3CP%3EDid%20you%20try%20pressing%20Ribbon%20-%26gt%3B%20Data%20-%26gt%3B%20Queries%20and%20Connections%20-%26gt%3B%20Refresh%20All%20(Excel%202016)%3F%20This%20will%20update%20your%20table%20to%20your%20database's%26nbsp%3Bmost%20up-to-date%20data.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-138665%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20won't%20refresh.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-138665%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eyou%20don't%20need%20to%20include%20the%20whole%20worksheet%20as%20the%20data%20source.%20If%20not%20all%20rows%20are%20populated%2C%20that%20is%20a%20waste%20of%20resources.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETurn%20your%20data%20into%20an%20Excel%20table%20(Insert%20%26gt%3B%20Table)%20and%20then%20reference%20the%20table%20as%20the%20source%20for%20the%20Pivot%20Table.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWithout%20seeing%20more%20information%20about%20your%20setup%20it%20is%20hard%20to%20tell%20why%20the%20pivot%20table%20is%20not%20updating.%20Check%20the%20data%20source%20settings%20of%20the%20pivot%20table.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-737592%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20won't%20refresh.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-737592%22%20slang%3D%22en-US%22%3EPivot%20table%20not%20getting%20refresh%2C%20after%20clicking%20refresh%2C%20%22%20msg%20showing%20PIVOT%20TAble%20cannot%20overlap%20another%20pivot%20table%2C%20but%20there%20is%20no%20another%20pivot%20table%20in%20that%20sheet.%22%3CBR%20%2F%3E%3CBR%20%2F%3EPls%20help%3CBR%20%2F%3E%3CBR%20%2F%3EAlso%20Refresh%20status%20not%20activated%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2422678%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20won't%20refresh.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2422678%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F96819%22%20target%3D%22_blank%22%3E%40Mark%20Fitzgerald%3C%2FA%3E%26nbsp%3BI%20just%20wanted%20to%20say%20thank%20you%20so%20much%20for%20posting%20this%20tip.%20I%20have%20searched%20the%20internet%20far%20and%20wide%20for%20a%20solution%2C%20and%20finally%20landed%20upon%20your%20comment.%20You%20just%20saved%20me%20from%20scrapping%20my%20entire%20spreadsheet!%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Pivot table won’t pull today’s numbers for each adjuster even though the data source covers entire worksheet and field is set up to count per adjuster name.  What am I missing? HELP!!!

 

Thanks,

Evangeline

4 Replies

Hello,

 

you don't need to include the whole worksheet as the data source. If not all rows are populated, that is a waste of resources.

 

Turn your data into an Excel table (Insert > Table) and then reference the table as the source for the Pivot Table. 

 

Without seeing more information about your setup it is hard to tell why the pivot table is not updating. Check the data source settings of the pivot table. 

Are you sure that the data source has the updated numbers?

Did you try pressing Ribbon -> Data -> Queries and Connections -> Refresh All (Excel 2016)? This will update your table to your database's most up-to-date data.

 

Do you have any filters set on your pivot table?  Sometimes filtered PTs don't recognize new items until you clear the filter.  

@Mark Fitzgerald I just wanted to say thank you so much for posting this tip. I have searched the internet far and wide for a solution, and finally landed upon your comment. You just saved me from scrapping my entire spreadsheet!