Syntax highlighting does not work in the advanced editor

Ivanov Ivan 26 Reputation points
2021-12-10T09:28:24.667+00:00

Syntax highlighting does not work in the advanced editor (Power Query)
I use.

  • Microsoft Office 2019 // Version 2112 (build 14729.20068)

How do I enable syntax highlighting?
Why doesn't syntax highlighting work?

156662-10122021-12-17-54.png

Microsoft 365 and Office | Excel | For business | Windows
Community Center | Not monitored
{count} votes

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff
    2021-12-13T07:46:18.643+00:00

    Hi @Ivanov Ivan ,
    Open Excel and go to Data- Get Data- Query options:

    157066-1.png

    Under Power Query Editor tab, make sure the Formula option is checked:
    157104-2.png

    Try this method and let me know if it works, I'm glad to help you.


    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.