Excel 2016 - No Intellisense and Missing Menu Item

Hi AussieBec ,
Thanks for posting in Microsoft Fabric Community,
Since IntelliSense isn’t working even though it's enabled, here are a few things to check:

1. Try using the Custom Column dialog or the Advanced Editor.

Check if predictive suggestions(Intellisense) appear in either of those - this helps isolate whether it’s a UI-specific issue.

2. Try updating Excel

Go to File > Account > Update Options > Update Now.

A partial or outdated install can sometimes cause editor features to not load correctly.

Also, just a quick note:

Power Query IntelliSense is only available in Excel 365 (subscription versions). It’s not supported in one-time purchase versions like Excel 2016 or 2019, even though they share the same version number (16.0).

Here are some related discussions:

Solved: Power query not guiding about function - Microsoft Fabric Community
Solved: My Intellisense dos not working in my Power Query ... - Microsoft Fabric Community

Hope this helps. Please reach out for further assistance.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and a kudos would be appreciated.

Thank you.