Share via

ltsc 2021 dynamic functions not available

Sriram Pusshparaj 0 Reputation points
2024-09-22T17:58:54.34+00:00

does office ltsc 2021 has dynamic functions or is it just my device doesnt have those functions. please advise

Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,155 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jiajing Hua-MFST 10,155 Reputation points Microsoft Vendor
    2024-09-23T05:46:18.59+00:00

    Hi @Sriram Pusshparaj

    Do you mean the dynamic array functions, like Sort, Filter, Unique functions do not work on your Excel 2021？

    If so, is there any error message? These dynamic array functions are supported on Excel 2021.

    I suggest you go to Excel, click File > Account, check the version number under "Product Information".

    You may click Update Options > Update Now, update Office to the latest.

    You may test these functions in Safe Mode. Please press and hold on Ctrl key, click or double-click Excel icon, until it asks if you want to start it in safe mode, then please release Ctrl key and click "Yes".

    • If these functions work in Safe Mode, please click File > Options > Add-ins > Manage COM Add-ins, click Go. Clear the check boxes for any enabled COM add-ins, select OK.
    • If not, it's recommended to perform an Online Repair from Control Panel.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.