Where the 'Link=' keyword is used in an NL function it is necessary to include filters for other tables above the Link= filterfield. To edit the function to include an additional filter (e.g. if requirements change or a filter had been omitted in error) requires editing in the Excel function bar to add two commas (,,) at the appropriate place in the formula string.

It would be nice to have the ability to  insert / delete / move the filter fields directly in the NL function wizard.   

NL FilterFields...

Attachments Open full size