To refresh an external data range automatically when the parameter value changes, you must select the parameter cell from ...

To refresh an external data range automatically when the parameter value changes, you must select the parameter cell from the same workbook as the external data range.

Click OK, and then select a cell in the same workbook in the Get The Value From The Following Cell box.