Share via

FILTER function in excel is not available

Anonymous
2022-09-17T04:35:23+00:00

Hi, I have subscribed to Microsoft Office 365 Pro Plus but FILTER function in my Excel is not available. Only FITERXML is available there. Hope someone can assist, thank you.

Below is My Product details

Majedul Hoque Chowdhury

Microsoft 365 and Office | Excel | For business | Other

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

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-09-17T05:22:48+00:00

    Dear Majedul,

    Greetings! Thank you for posting in Microsoft forum.

    From the screenshot, I noticed your Office apps are still appearing as Office Professional Plus 2019 and this is the reason FILTER function doesn't appear. Please try the following steps to activate with your Office 365 Pro Plus account:

    1. Open any Microsoft 365 app, sign out (sign out from all the accounts you are currently signed in with) and close all the Office 365 applications opened on your system. To sign out, open any Office application, let’s say Word or Excel, click File>Account>Sign out and then quit all Office apps.
    2. Open Control Panel>User Account>Credentials Manager>Windows Credentials.
    3. Under Generic Credentials, look for any entries containing MicrosoftOffice16 and MicrosoftOffice15 credentials and Remove all.

    If you don’t see MicrosoftOffice16 and MicrosoftOffice15 in Control Panel>Windows Credentials, then simply sign out from Microsoft Office apps and enter your Microsoft 365 log in credentials and **then re-start the Office app (**re-starting the apps is necessary after signing in with Microsoft 365 credentials).

    If the issue remains, please repair Office apps from Control Panel instead.

    1. Click the Start button > Control Panel. From Category view, under Programs, select Uninstall a program.
    2. Click Microsoft 365 apps, and then click Change and select Online Repair.

    Please try Online repair. Quick repair only detects and then replaces corrupted files, and an Online repair option will do a complete repair; it will take a few extra minutes to repair Office applications.

    After repairing Office apps, check if you see the mentioned functions in Excel. If you need any help, let us know. We will look forward to your reply. Stay safe and stay healthy.

    Sincerely,

    Neha Singh | Microsoft Community Moderator

    0 comments
  2. Anonymous
    2022-09-17T09:06:02+00:00

    I did all this things, but still problem exist, as i guess may problem is with my license key, there for could you please tell me, how can i evaluate that my license 365 or not? or this issue is relevant with license or not.

    0 comments
  3. Anonymous
    2022-09-19T23:26:47+00:00

    Hi Majedul,

    Thanks for replying.

    May I know which Microsoft 365 subscription you have? If you have Microsoft 365 subscription through your work or school, please check the Subscriptions page, you can access this page via this link.

    In case, you have Microsoft 365 personal/family subscription, please check the Services & subscriptions page to verify the subscription and let me know.

    Regards,

    Neha

    0 comments