Power Query - importing Dynamic Named Ranges ("=Excel.CurrentWorkbook()")

[SorenPetersen]

Hi!

I have added a dynamic Range (name: "DynamicRange") in this file, but I am not able to connect to it (using the "=Excel.CurrentWorkbook()" in the formula bar.

Any help?!?!

Attatched file: "Excel Data.xlsx".

 

[Ken Puls]

Hi Soren,

Sorry for the very late reply here, just saw this. Yes, this is a known issue in Excel 2016. Fortunately it appears to FINALLY be fixed with the March update. (I'm on an insider build 16.0.6729.xxxx)

Of course, I'm assuming you're on Excel 2016. Hopefully with the next update this will be fixed for you.

 

[SorenPetersen]

Hi - and thank you for your reply. And YES - I can see that it Works now (updated to 16.0.6741.2021). Thanks a lot!