Ask a new question

How to fix Excel Pivot filters for Mac where date filers are being applied to text values?

Hello,

 

In the last few days, the filters on my pivot tables have stopped working like they usually do. Normally I am able to filter “By Label” and the drop down menu has operators that have “Contains”, “Does not Contain”, “Begins with”, “Ends with”, “Equals, etc. for my text data.

 

Now the “By Labels” filter is treating the data as a date with “After”, “Between”, “Tomorrow”, “This Week”, etc.

 

I have tried the following to get it work normally:

 

  • Copied a file that worked in the past, which started off working normally within the pivots and then had the same issue

  • Changed the cell format to “Text” vs “General”

  • Re-selected my source data via “Change my Source Data”

  • Refreshed my Data in the pivot sheet

  • Restarted Excel

  • Restarted my Mac

  • Checked for the latest Excel updates (I have the latest version of 16.84)

 

Please find the screenshot of the issue. It shows the leftover filter that was working a few days ago, and now Excel is only giving date filters despite the text option still actively filtering.




Is this a bug or is there something that’s changed?

Thank you.

Note: This sounds like the same issue found on this post and this post.

|

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.

It seems bug. I'd suggest you create a support ticket to Microsoft.

Please contact your admin/IT department create a support ticket via Microsoft 365 Admin Center> Support> New service request. Support team there will have the correct channel and resources to help you investigate more and find what exactly the reason has caused this situation.

Get support - Microsoft 365 admin | Microsoft Learn

About how to find the admin in your organization, you can refer to How do I find my Office 365 admin

•Beware of Scammers posting fake Support Numbers here.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Thank you, Snow. I'll reach out to my IT department to get a support ticket created.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hi Snow, I was wondering if there is a workaround for this issue? I've continued to troubleshoot as our IT department is still working on sending the service ticket. Other members of my team are encountering the same issue with their Macs.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Have you tried inserting a slicer of that field?

•Beware of Scammers posting fake Support Numbers here.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

I have, and was not able to filter our the data I needed.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Could you share a test file to reproduce your issue?

You may upload file in private message.

Private Messages - Microsoft Community

•Beware of Scammers posting fake Support Numbers here.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Yes, I've sent you a message. Thank you.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

I've also had a colleague of mine try to use the same function on a Windows machine, but it is having the same error.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Here is my test on Windows Machine.

1. Select Description field

2. Use filter

Image

You may also try the clear filter first.

•Beware of Scammers posting fake Support Numbers here.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hi Snow, I don't have the same options as you on my Mac. This is what I see:

This also happens to new Excel sheets I start.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.

 
 

Question Info

Last updated May 17, 2024 Views 84 Applies to: