Forum Discussion

Awesome390's avatar
Awesome390
Copper Contributor
Feb 05, 2025

functions in power query do not work

When I click on Conditional column button, I get a blank box and I cannot do anything. This looks like a Microsoft bug.

I clicked on Invoke Custom Function, that also gives me a blank box like below.

Yes Microsoft Excel is up to date. I am on company license and seem to get automatic updates.

 

  • Try closing the PQ window and open it again.

    If that does not help close Excel and open it again.

     

  • Such ghost window could be closed by Esc or Alt+F4 assuming you focused on it. Depends on situation only one could work, not any of them (which is more usual).

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor

    Try closing the PQ window and open it again.

    If that does not help close Excel and open it again.

     

    • Awesome390's avatar
      Awesome390
      Copper Contributor

      Thank you, that did work. I still think it is a bit buggy.

Resources