Filtering Dynamic Tables in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1766823%22%20slang%3D%22en-US%22%3EFiltering%20Dynamic%20Tables%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1766823%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20complex%20Workbook%20with%2028%20worksheets.%20Several%20of%20them%20are%20Dynamix%20Tables.%20Most%20of%20them%20work%20finely.%20But%20two%20of%20them%20show%20values%20that%20no%20longer%20exist%20in%20ANY%20worksheet.%20I%20have%20eliminated%20those%2C%20saved%20the%20workbook%20close%20the%20workbook%20and%20opened%20it%20again.%20When%20I%20try%20to%20built%20them%20from%20the%20beginning%20the%20same%20values%20appear%20only%20when%20filtering%20but%20the%20Dynamic%20Table%20works%20fine.%3C%2FP%3E%3CP%3EWhy%20are%20there%20false%20values%20in%20the%20filtering%20drop%20down%20menu.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGustavo%20Lira%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1766823%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

I have a complex Workbook with 28 worksheets. Several of them are Dynamix Tables. Most of them work finely. But two of them show values that no longer exist in ANY worksheet. I have eliminated those, saved the workbook close the workbook and opened it again. When I try to built them from the beginning the same values appear only when filtering but the Dynamic Table works fine.

Why are there false values in the filtering drop down menu.

 

Regards

 

Gustavo Lira

0 Replies