Share via

New functions for Excel 2019 are not available

Anonymous
2020-07-06T18:44:42+00:00

New functions e.g., Textjoin, Concate, Ifs, Switch are not available in Excel 2019 version 2007 (Build 13029-20006) updated till today. I remember that earlier I have used "Textjoin" but now it is not list in formula list. If I enter a function, result shows error as #Name .

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

Answer accepted by question author

  1. Anonymous
    2020-07-15T17:07:44+00:00

    I'm glad that the issue was solved by re-installing Windows operating system. In the future, If you'll have Office apps concern, please don't hesitate to post back to the Community Forum.

    Regards,

    Bob

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments

9 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-07-10T15:06:59+00:00

    Please do so and update us with the outcome.

    Bob

    Was this answer helpful?

    0 comments
  2. Anonymous
    2020-07-09T08:04:04+00:00

    Functions are missing probably after an update, which update I can't point out bcz I've used "Textjoin" earlier but now when I tried to use it again then found that all the new functions are missing/not available in functions list.

    However thanks for your guidance. I'll try to reinstall the office suite and will share my experience with you.

    Regards

    Zaigham

    Was this answer helpful?

    0 comments
  3. Anonymous
    2020-07-09T01:25:18+00:00

    Hi, 

    I understand that you're unable to use the new functions in the Excel app like TEXTJOIN, CONACTATE, IFS, and SWITCH . Don't worry. Let me assist you.

    The Excel functions are available in your Office suite, it is possible that a corrupted system file is the cause why this issue is happening. Before we get to troubleshoot the app, please check this Microsoft articles about how the new function works in the Excel app because you might have missed something that is why the error appeared. 

    If after checking the instructions on how to use these features and you still have the same issue, you can try the following Microsoft articles to help solve the issue. 

    1. Install Office updates
    2. Repair an Office application****
    3. Uninstall Office from a PC****
    4. Download and install or reinstall Office 365 or Office 2019 on a PC or Mac****

    Let us know how it goes. 

    Bob

    Was this answer helpful?

    0 comments
  4. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more