Office 365 Subscription - New functions unavailable in Excel - Microsoft Community

dear all,

so i've subscribed office 365 (for 1 person) can new exclusive features , functions such ifs, textjoin , on.

unfortunately seems no matter still unavailable:

i've tried use office removal tool make sure previous version out of window:

https://support.office.com/en-us/article/uninstall-office-from-a-pc-9dd49b83-264a-477a-8fcc-2fdf5dbf61d8?ui=en-us&rs=en-us&ad=us

and reinstall no luck. (it said couldn't uninstall click-to-run, not sure if issue).

i've tried use office deployment tool suggested michael de wever in thread:

https://answers.microsoft.com/en-us/office/forum/office_2016-excel/new-excel-2016-functions-not-working-in-desktop/cef17d5f-c914-4442-81ec-38d0b10e828a/?auth=1

and still no luck..

i'm date according office.

my version:

i don't know i'm doing wrong start feel maybe i've subscribed version doesn't include these. :(

any appreciated.

thank much,

take care,

gábor

the screen cap showed of dialog shows have build 8326.2076. have been current version on date.  if go page:

https://support.office.com/en-us/article/version-and-build-numbers-of-update-channel-releases-ae942449-1fca-4484-898b-a933ea23def7?ui=en-us&rs=en-us&ad=us#bkmk_bydate

it shows version , build numbers various "channels".  unless told otherwise assume have current channel. or try find channel closest build number.

that page shows few days later current build number 8326.2087.  side note, today still have same build number do, no "automagic" update me, yet ...

the key point should have of "missing" features identified in build.

so appears have 2 different problems.

the original 1 potential lack of "new features" limited office 365.

they may there. did try using/typing ifs() , textjoin() etc functions, though did not appear hint list?  may working, not included in list.  if commands not work, reflect problem in build itself!  worth reporting ms.

after trying them, should report issue, either don't see new functions in popup prompt or totally not included excel specific uservoice forum.  can in excel going file menu > feedback command > send suggestion button go directly excel uservoice.

your other problem appears issues office install / update / repair.  report office uservoice forum link nick provided.

Office / Excel / Windows 10 / Office 365 Home