locked
Get the value of the named range stop to work in 2016 excel , 64-bit ? RRS feed

  • Question

  • Hello,

    We have been using

    Excel.CurrentWorkbook(){[Name="somRange NAme"]}[Content]

    for quite some time now to get the value of the named range.

    Today I opened one of the worksheet that relies on it  and the query that's using named range value failed to refresh.

    When I track it down, i found out that the Excel.CurrentWorkbook returns null instead of the value.

    Anybody experiences the same behavior ?

    Thanks for any input

    Pavel

    Thursday, April 7, 2016 9:34 AM

Answers

  • Hi Pavel. This is a known issue, and we're working on a fix. You can find more info here:

    https://social.technet.microsoft.com/Forums/en-US/2e84ee3f-e417-4f9c-94f3-bf65c7e6b81b/issue-with-getting-a-named-range-table-content-into-power-query-get-amp-transform-in-excel-2016?forum=powerquery

    Ehren

    Thursday, April 7, 2016 7:46 PM

All replies

  • Hi Pavel. This is a known issue, and we're working on a fix. You can find more info here:

    https://social.technet.microsoft.com/Forums/en-US/2e84ee3f-e417-4f9c-94f3-bf65c7e6b81b/issue-with-getting-a-named-range-table-content-into-power-query-get-amp-transform-in-excel-2016?forum=powerquery

    Ehren

    Thursday, April 7, 2016 7:46 PM
  • Hello Ehren,

    Thanks for explanation.

    Cheers

    Pavel

    Friday, April 8, 2016 7:23 AM