Pivotable Parameters

[Trevor Cook]

I'm trying to pass a parameter to MSQuery when connecting to an external datasourse for use in a Pivotable but get the error "Parameters are not allowed for this query". Does anyone have a workaround for this problem.

Many thanks
Trevor