Intellisense not working in Power Query Editor for Excel

Question

In Power Query for Excel, Intellisense does not work in any of the places where it should (Advanced Editor, Formula Bar, Add custom column dialog).

It was properly selected in Query Options:

I have Microsoft 365 Excel Version 2211 (Build 15831.20190 Click-to-Run) Current Channel (64 bit) running on Windows 11.

I have done an "online repair" of my Microsoft 365 installation.

I have no idea if this is relevant, but intellisense does work as expected in the PQ Editor in Power BI Desktop, just not in the PQ Editor in Excel.

TIA for any help.

Answer 1

Hello, I am Leonielhou, an Independent Advisor and a user like you, I am happy to help clarify any questions you may have.

Since you have done Quick Repair, kindly try to uninstall and then reinstall Office. Please refer to this link:

https://support.microsoft.com/article/4414eaaf-0478-48be-9c42-23adc4716658?ui

May I know if my answer was able to settle everything for you? If there's anything else you need help with, please let me know right away. I'm always happy to help out where I can.

Thank you for your time and have a wonderful day. Cheers!

Best, Leonielhou

Answer 2

In the English language Online Repair is NOT Quick repair. They are two separate options from the Add/Remove Programs dialog. And Online Repair does do a complete re-download of the Microsoft 365 files and apps.

Answer 3

Hi.

When you say not working, do you mean that when you write " = " in a cell and press a letter, intellisense formulas won't show up?

Answer 4

That is exactly what I mean.

Answer 5

Does anyone have a solution to this issue, please?