asked on

Textjoin function not showing on 365 Subscription

Hi, I have Office 365 subscription and Windows OS. On one computer I have the TEXTJOIN function whereas it is not available on the other. I remember having to enable it on my first computer (probably because it was in beta testing?). Now I understand that this is a permanent feature of Office 365 Home subscription.

Can someone tell me why it is not working on the other computer.

Also the first computer has option of autosave near the top left but not available on the second computer.

ASKER CERTIFIED SOLUTION

Roy Cox

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

S_K_S

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

byundt

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

byundt

I guess it is also possible that updates have been blocked on a valid Office 365 subscription. For Office 365, you'll see your version number to the right of About Excel in the File...Account menu item, as shown in the top screenshot above.

Office 365 Home is supposed to get monthly updates. So I checked to see when the TEXTJOIN and AutoSave features were added. You can decode the version number as year and month in yymm format. So Version 1601 is January 2016, and version 1707 is July 2017.

Version 1601 of the Monthly channel brought the TEXTJOIN and CONCAT functions. https://docs.microsoft.com/en-us/officeupdates/monthly-channel-2016

Version 1707 of the Monthly channel brought the AutoSave feature. https://docs.microsoft.com/en-us/officeupdates/monthly-channel-2017

Saqib Husain

ASKER

It turned out that the installation was not the subscription version.

Thanks to all.

Roy Cox

Pleased we could help