Forum Discussion
My Intellisense dos not working in my Power Query Editor for Excel
OK, Then
after a long conversation (almost two hours) with a Microsoft support person, we came to the conclusion that it does not work in the Hebrew version of power query, these are only in the English version, as of this time.
Many thanks to everyone who helped or tried to helpHow do I close this topic (well, in the end I didn't get a solution from this forum)?
Community ChampionHave you verified within Power Query Options for the Power Query Editor and Formula that "Enable M Intellisense in the formula bar, advanced editor, and custom column dialog" has a checkmark next to it?
Refer to Ken Puls aged blog post on the subject that is helpful.
Power Query Intellisense and Highlighting in Excel
Steps to enable or disable Intellisense support in Excel for Power Query
- Open Power Query Editor
- File | Options and settings | Query Options | Global | Power Query Editor | Formula >
- enable by adding a checkmark to the left of
- Enable M Intellisense in the formula bar, advanced editor, and custom column dialog.
- Click OK.
- Close Power Query Editor
- Open Power Query Editor
- Create a new blank query and test that Intellisense is active.
Hi, thanks for the reply
I forgot to mention that my office is in the Hebrew version
And in this version I don't have the formula option, as you can see in the screenshot.
In the English version, there is no problem, and it works fine.
Best regards
Doron- foodd
What version of Microsoft Office is this? Is it a Subscription, and what level of Subscription? Please reply with the Version and Build information from Excel or Microsoft Office and add that information to a reply.
For example, this is a screenshot from Microsoft 365 and an E3 Plan. As well, the installation
is on the BETA Channel. What Operating System, and is this 32-Bit or 64-Bit?
thise is my version