Pivot Table is not picking up all values from Filter Table

%3CLINGO-SUB%20id%3D%22lingo-sub-2505041%22%20slang%3D%22en-US%22%3EPivot%20Table%20is%20not%20picking%20up%20all%20values%20from%20Filter%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2505041%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Team%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hoping%20if%20you%20can%20help%20me%20fix%20my%20OneDrive%20Excel.%26nbsp%3B%3C%2FP%3E%3CP%3EAfter%20manually%20adding%20up%20the%20numbers%2C%20I%20found%20out%20my%20Pivot%20Table%20is%20not%20picking%20up%20all%20the%20values%20listed%20in%20the%20Filter%20Table%20from%20another%20sheet.%3C%2FP%3E%3CP%3EI%20tried%20a%20lot%20of%20the%20recommendations%20to%20get%20it%20fixed%20but%20I%20think%20I%20missing%20something%20here.%20Can%20you%20please%20help%20me%20with%20it.%26nbsp%3BI%20can%20send%20you%20a%20copy%20of%20my%20excel%20document.%20Can%20you%20please%20provide%20me%20an%20email%20for%20this%20request.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2505041%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2514918%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%20is%20not%20picking%20up%20all%20values%20from%20Filter%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2514918%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1092590%22%20target%3D%22_blank%22%3E%40lillina%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELet's%20take%20a%20look%20at%20your%20workbook%2C%20you%20can%20click%20on%20my%20name%20and%20private%20message%20the%20file%20to%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2515552%22%20slang%3D%22en-US%22%3EBetreff%3A%20Pivot%20Table%20is%20not%20picking%20up%20all%20values%20from%20Filter%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2515552%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1092590%22%20target%3D%22_blank%22%3E%40lillina%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%22%20target%3D%22_self%22%3E%3CSPAN%3EWelcome%20to%20your%20Excel%20discussion%20space!%3C%2FSPAN%3E%3C%2FA%3E%3C%2FP%3E%3CP%3EIf%20you%E2%80%99re%20looking%20to%20ask%20a%20question%20or%20start%20a%20conversation%20about%20Excel%2C%20you%E2%80%99re%20in%20the%20right%20place!%26nbsp%3B%20Ask%20away.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20include%20the%20following%20info%20to%20help%20others%20answer%20your%20question%3A%3C%2FP%3E%3CUL%3E%3CLI%3E%3CSTRONG%3EDevice%20and%20OS%20platform%3C%2FSTRONG%3E%2C%20e.g.%2C%20PC%2FWindows%2010%20(see%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fwindows%2Fwhich-version-of-windows-operating-system-am-i-running-628bec99-476a-2c13-5296-9dd081cdd808%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EWhich%20version%20of%20Windows%20operating%20system%20am%20I%20running%3F%3C%2FA%3E)%20or%20Mac%2FmacOS%20Big%20Sur%2011.2.1%20(see%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.apple.com%2Fen-us%2FHT201260%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EFind%20out%20which%20macOS%20your%20Mac%20is%20using%3C%2FA%3E)%3C%2FLI%3E%3CLI%3E%3CSTRONG%3EExcel%20product%20name%20and%20version%20number%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E(see%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fabout-office-what-version-of-office-am-i-using-932788b8-a3ce-44bf-bb09-e334518b8b19%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAbout%20Office%3A%20What%20version%20of%20Office%20am%20I%20using%3F%3C%2FA%3E)%3C%2FLI%3E%3CLI%3E%3CSTRONG%3EExcel%20file%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSTRONG%3Eyou%E2%80%99re%20working%20with%20or%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3Esample%20file%20with%20data%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%E2%80%93%20please%20remove%20all%20confidential%20and%20PII%20data%26nbsp%3B%3C%2FLI%3E%3CLI%3EAs%20much%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3Econtext%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eof%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3Ewhat%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eyou're%20trying%20to%20do%20-%20and%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3Ewhy%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E-%20as%20possible%2C%20e.g.%2C%20how%20what%20you're%20trying%20to%20do%20fits%20into%20what%20larger%20process%20or%20workflow*%3C%2FLI%3E%3CLI%3E%3CSTRONG%3EExpected%20result%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eand%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3Emethod%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eto%20achieve%20the%20result**%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOnce%20you%20got%20a%20good%20answer%20to%20your%20question%2C%20please%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3Eaccept%20it%20as%20solution%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eto%20help%20others%20looking%20for%20answer%20to%20the%20same%2Fsimilar%20question.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi Team,

 

I hoping if you can help me fix my OneDrive Excel. 

After manually adding up the numbers, I found out my Pivot Table is not picking up all the values listed in the Filter Table from another sheet.

I tried a lot of the recommendations to get it fixed but I think I missing something here. Can you please help me with it. I can send you a copy of my excel document. Can you please provide me an email for this request.

 

 

2 Replies

Hi @lillina,

 

Let's take a look at your workbook, you can click on my name and private message the file to me.

 

Cheers

@lillina 

 

Welcome to your Excel discussion space!

If you’re looking to ask a question or start a conversation about Excel, you’re in the right place!  Ask away.

 

Please include the following info to help others answer your question:

 

Once you got a good answer to your question, please accept it as solution to help others looking for answer to the same/similar question.

 

Thanks!