Home

Pivot Table New Data Issues

%3CLINGO-SUB%20id%3D%22lingo-sub-73923%22%20slang%3D%22en-US%22%3EPivot%20Table%20New%20Data%20Issues%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-73923%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20look%20after%20scheduled%20servicing%20for%20a%20earthmoving%20company.%20A%20big%20part%20of%20that%20is%20machine%20hours.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20developed%20a%20pivot%20table%20that%20filters%20on%20all%20active%20machinery%20ID's%20and%20their%20respective%20hours.%3C%2FP%3E%3CP%3EThe%20report%20works%20great!%20It%20updates%20the%20hours%20within%20the%20pivot%20table%20each%20time%20i%20dump%20new%20data%20into%20it.%20Only%20issue%20is%2C%20when%20a%20new%20piece%20of%20equipment%20shows%20in%20the%20raw%20data%2C%20it%20does%20not%20show%20up%20in%20the%20pivot%20table.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can%20see%20the%20new%20equipment%20ID%20within%20the%20pivot%20table%20filters%2C%20but%20it%20will%20not%20automatically%20select%20and%20show%20in%20the%20pivot%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAm%20I%20missing%20a%20setting%20here%20where%20I%20can%20tell%20the%20pivot%20table%20to%20automatically%20include%20all%20new%20items%20within%20a%20column%20so%20it%20shows%20up%20in%20the%20pivot%20table%3F%20(i.e%20new%20equipment%20numbers).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-73923%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-73933%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%20New%20Data%20Issues%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-73933%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Jake%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FChange-the-source-data-for-a-PivotTable-ad8ed968-ada1-4dde-9f72-30e07782dccd%3FCorrelationId%3Dd20498ea-a72e-4922-9de5-91d8b4aadad7%26amp%3Bui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%26amp%3BfromAR%3D1%26amp%3BocmsassetID%3DHA102840036%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EDid%20you%20change%20the%20source%20data%20source%20for%20the%20pivot%20table%3F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Jake Harris
Occasional Visitor

Hi all!

 

I look after scheduled servicing for a earthmoving company. A big part of that is machine hours.

 

I have developed a pivot table that filters on all active machinery ID's and their respective hours.

The report works great! It updates the hours within the pivot table each time i dump new data into it. Only issue is, when a new piece of equipment shows in the raw data, it does not show up in the pivot table. 

I can see the new equipment ID within the pivot table filters, but it will not automatically select and show in the pivot table.

 

Am I missing a setting here where I can tell the pivot table to automatically include all new items within a column so it shows up in the pivot table? (i.e new equipment numbers).

 

Thanks for your help!

 

1 Reply
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
50 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
32 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
15 Replies
Discussion - Updating our interface with Fluent touches
Elliot Kirk in Discussions on
102 Replies