Excel filter issues

%3CLINGO-SUB%20id%3D%22lingo-sub-1803324%22%20slang%3D%22en-US%22%3EExcel%20filter%20issues%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1803324%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI've%20got%20an%20excel%20table%20with%205%20colums%20and%20each%20colum%20has%20different%20type%20of%20data%2C%20the%20problem%20is%20the%20content%20of%20those%20colums%20are%20not%20being%20automatically%20selected%20while%20filtering.%20what%20should%20I%20do%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1803324%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1803366%22%20slang%3D%22de-DE%22%3ESubject%3A%20Excel%20filter%20issues%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1803366%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F840607%22%20target%3D%22_blank%22%3E%40Joe_Nd03%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20your%20permission%2C%20if%20I%20can%20recommend.%20It%20can%20help%20us%20all%20if%20you%20upload%20an%20Excel%20file%20(without%20sensitive%20data)%2C%20no%20picture.%20Even%20if%20it%20is%20said%20that%20a%20picture%20can%20say%20a%20thousand%20words%2C%20it%20is%20certainly%20not%20in%20the%20case%20of%20Excel%2C%20on%20the%20contrary%20in%20some%20cases.%20This%20would%20also%20be%20a%20blessing%20for%20all%20of%20us%2C%20as%20we%20can%20understand%20the%20problem%20much%20better%2C%20a%20win-win%20situation%20for%20everyone.%3C%2FP%3E%3CP%3E*%20Knowing%20the%20Excel%20version%20and%20operating%20system%20would%20be%20an%20advantage.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1803465%22%20slang%3D%22en-US%22%3EBetreff%3A%20Excel%20filter%20issues%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1803465%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eunfortunately%20the%20table%20I%23mm%20working%20on%20contains%20sensible%20data%2C%20i%20would%20have%20loved%20to%20post%20it%20coz%20a%20really%20need%20help%20but%20I%20can't.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi,

I've got an excel table with 5 colums and each colum has different type of data, the problem is the content of those colums are not being automatically selected while filtering. what should I do?

5 Replies
Highlighted

@Joe_Nd03 

With your permission, if I can recommend. It can help us all if you upload an Excel file (without sensitive data), no picture. Even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases. This would also be a blessing for all of us, as we can understand the problem much better, a win-win situation for everyone.

* Knowing the Excel version and operating system would also be an advantage.

 

 

Thank you for your understanding and patience

 

 

Nikolino

 

I know I don't know anything (Socrates)

Highlighted

@Nikolino 

unfortunately the table I#mm working on contains sensible data, i would have loved to post it coz a really need help but I can't.

 

Highlighted
* Knowing the Excel version and operating system would also be an advantage.
Highlighted

@Joe_Nd03 

The problem could be complex or very simple, but without a file (without sensitive data) it's hard to guess.

There is a possibility with the worksheet compatibility, here is some information.

But the problem could also be due to the formula.

Worksheet compatibility issues

https://support.microsoft.com/en-us/office/worksheet-compatibility-issues-f9c80c5b-5afc-40da-a841-b8...

 

I hope I could help you with that.

 

Thank you for your time and patience

 

Nikolino
I know that I know nothing(Socrates)

Highlighted

@Joe_Nd03 

It's not necessary to submit your working file, you may generate small sample to illustrate an issue. That's 5 minutes job.