PDA

View Full Version : Power Query - importing Dynamic Named Ranges ("=Excel.CurrentWorkbook()")



SorenPetersen
2016-01-08, 12:37 PM
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
2016-03-31, 07:00 PM
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
2016-04-02, 06:36 AM
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!