locked
Query Function Works in Excel 2013 but not Excel 2016 RRS feed

  • Question

  • Created a function in Excel 2013 to filter the query based on a value the user inputs in a cell in the workbook.  It works fine in Excel 2013 but doesn't return a value in Excel 2016.  Your help would be appreciated.

    Here is the function:

    let GetValue=(DRMID) =>

        let 

           name = Excel.CurrentWorkbook(){[Name=DRMID]}[Content],

           value = name{0}[Column1]

        in

           value

        in GetValue


    ChrisM26

    Monday, March 28, 2016 11:08 PM

Answers