Excel.CurrentWorkbook() not working

Have you used:

Formula:

= Excel.CurrentWorkbook()

And have you done it in appropriate place?:
In excel ribbon select Data (1) then New Query (2), Empty Query and now in Query editor (3) write the formula (4)

Screenshot is from national version of excel, but location of controls is the same in English one.

By the way it does not list all objects. It lists all tables only. If you want to refer to named ranges procedure is a bit more complicated. see for instance https://blog.crossjoin.co.uk/2014/07...n-power-query/