Share via

Excel array formulas not showing

Anonymous
2022-01-15T23:36:04+00:00

Hi,

I just installed latest version of office 365. However my excel is not showing the array formulas for example filter, unique etc.

Will appreciate if anyone can help.

I have the latest version downloaded.

Microsoft 365 and Office | Excel | For home | MacOS

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
Answer accepted by question author
  1. Anonymous
    2022-01-16T07:41:42+00:00

    Hi Rushan_263：

    In our tests, we did not encounter the same problem, the filter formula works fine in 16.57 version of Excel for Mac.

    If the problem persists, please try running Office by starting up your Mac in safe mode to see the result. This can help us check whether issues you are experiencing are caused by software that loads as your Mac starts up.

    Another suggestion is to remove the Office folders to desktop:

    • Completely quit all Office apps
    • In Finder, press COMMAND +Shift+g.
    • Enter**~/Library** and click Go.
    • Go to Containers folder, find the folder called com.Microsoft.Excel
    • Move this folder to your desktop by cut & paste.
    • Relaunch Word for Mac application and see the results.

    If the problem persists, Pplease try switching a Mac user to see if this fixes the issue .

    Hope this will help you.

    Best regards,

    Tin

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-01-16T15:04:32+00:00

    Thanks for the quick reply, its working now!!

    0 comments