Is it possible to open two Excel files at the same time and do a heterogeneous (cross) query? The error displaying is:
“You are not able to use these connections connection1 and connection2 in the same cross query”
In version 3.1 and below, it is not possible to run a cross-query against 2 Excel Files due to the limitation of the Access Jet Database Engine used to aggregate the data.
In version 3.2 and above it is possible, but only with the Professional Edition. The Base Edition still utilizes the Access Jet Database Engine and will display an error message as described above.
Please refer to knowledge article 105595 for further information and video on how to create and execute cross queries.