User getting error in Excel online " Not all unique items in the column are shown."

Anonymous
2024-01-19T11:18:23+00:00

User getting error in Excel online " Not all unique items in the column are shown." but can-do filter on desktop app without any issue. We have tried on multiple users and browsers, but same issue.

Can anyone help me is this limitation or less features in Excel online? or something else if you have suggestions.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2024-01-19T12:34:54+00:00

    Hi Ganiknp,

    Thank you for reaching out. My name is Leo, a user just like you. I'd be happy to help you with your concern.

    May I know what was done before you encountered the issue? What options or formulas were used? It would be very helpful if you could provide a screenshot and more information regarding the issue for us to understand it better. Please note that the online version of Office Excel and the desktop version have different features available. There are limitations in the online version that are only available in the desktop version. For this error, it might be the case. If you want to fully utilize the features of Office apps, it is recommended to use the desktop version. We will wait for your response for further investigation. In case you still need assistance, please don't hesitate to post it here in this forum. We, the community users, are always here to help. Thank you!

    Your understanding and patience will be highly appreciated. I hope I provided a helpful information regarding your concern! Let me know if you have any further questions. Be safe always!

    Best Regards,

    Leo

    Was this answer helpful?

    0 comments
  2. Anonymous
    2024-03-07T01:20:42+00:00

    As of March 2024

    Excel Online seems to have a lower limitation on the Filter Option compared to the Desktop App version. We could not see dates up to a point online but was able to see it on the desktop app.

    Our issue got resolved by hiding data that was not actively used, we had data from 2022 and before so we just set row to "hide"or be hidden.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments