PQ functions not showing in Connections

[macfuller]

Office 365/Excel 2016 I've started to see odd behavior in functions I add to Power Query. They work OK but are not showing up in ActiveWorkbook.Connections enumerations.

Here is a simple function.

(PO_Code as text) => 
let
    values = {
    {"BLKT", "Blanket"},
    {"L", "Lease"},
    {"PF", "Physical Facilities"},
    {"RENT", "Rental"},
    {"REP", "Repair"},
    {"SINV", "Summ Invoice"},
    {PO_Code, "Other"}
     },
     Result = List.First(List.Select(values, each _{0}=PO_Code)){1}
in
    Result

This loads and works, but when I hover over it in the Queries and Connections pane it says "The Workbook connection couldn't be created" and I don't have a Load To option under the Edit button. Is this new behavior or (ugh) do I need to uninstall and reinstall Excel?

 

[nikio8]

Works fine for me. Did you try close and open ? hehe
Sometimes you need to fully close excel. i had many times one sheet open causing touble

 

[macfuller]

I closed and rebooted several times. On spreadsheets created before this mid-July change the existing functions show a connection, but new ones that I add give the error. And there's no frown to send the message to MSFT!