Trying to use Excel Query Editor and its Parameter Manager in conjunction with the "Create Function" from Navigation pane on a query. In Parameter Manager the following issues: creating a parameter with "Suggested Values" = Query; the Query dropdown box: 1) does not list all of the query names in project; 2) dropdown box extends beyond the edge of the Parameter Manager dialogue box; 3) sometimes the dropdown box is hidden behind the task bar at the bottom of my screen. When "Suggested Values" is "Query", "Query" dropdown has a selected query name and "Current Value" has another query name and the parameter is passed to a function the error message is produced that says "We cannot convert the value of (a literal) to type Table. It is not clear why there needs to be a "Current Value" since a query is listed in the query box. To get the "Create Function" to recognize that a parameter exists it seems the parameter must be defined in Parameter Manager. The query type parameter is not passed to the "Create Function" or so it seems. The Parameter Manger Type box does not include type Table, even though it is normal to pass tables as arguments to functions. The "Any" type does not seem to support type Table. Please explain how this is supposed to work?

