I have created a detailed MS Access Query which references a PASS THROUGH query. This runs perfectly within Access. If I then attempt to access this query from a pivot table in Excel (all 2016) it will not load. If I remove any reference to the PASS THROUGH query all works ok in Excel.
Q.? Can Excel run MS Access queries which reference PASS THROUGH queries.