Share via

I am missing sort and unique function in excel 365 proplus

Anonymous
2024-02-10T15:18:03+00:00

I am no longer able to use the sort and unique function in excel. How do I get them back. I have 365 proplus

Microsoft 365 and Office | Excel | For business | 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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-02-10T18:01:27+00:00

    Dear respected Fin Mgr,

    Welcome to this Microsoft Community.

    Based on the description shared, it seem you are not able to use the Unique and Sort function in the Excel workbook.

    If my understanding is correct, please follow the below steps and check the outcome:

    Step 1: Quit all Office apps except one Office app such as Excel> Account> Sign out from all Office 365 accounts> Quit all Office apps.

    Step 2: Open the Control Panel> User Accounts> Credential Manager> Windows Credentials> Remove the credentials related to Office apps.

    Step 3: Reset the Office apps activation state: Reset activation state for Microsoft 365 Apps for enterprise - Microsoft 365 Apps | Microsoft Learn (Method: Use scripts to automate the cleanup process)

    Step 4: Restart your PC> Open any Office apps such as Excel> Sign in with your account and check the outcome.

    If the problem persists, can you please provide the screenshot of the Excel app Account page? Open the Excel workbook> File> Account> Take a screenshot and share it with us.

    Appreciate your patience and understanding and thank you for your time and cooperation.

    Sincerely,

    Mia | Microsoft Moderator

    Was this answer helpful?

    0 comments