J
jpx
Can anyone tell me an easy way to figure out if queries are present
within a particular worksheet. For example I have a very large excel
sheet with multiple sets of data within the same sheet. I want to know
if any of that data was created via a query and if so how many
different queries exist within that sheet. I know that by trial and
error if I clcik on a random cell, that happens to be within a query
range, I will see the Data/Get External Data/Edit Query option able to
be selected. But that is just trial and error. Thanks.
within a particular worksheet. For example I have a very large excel
sheet with multiple sets of data within the same sheet. I want to know
if any of that data was created via a query and if so how many
different queries exist within that sheet. I know that by trial and
error if I clcik on a random cell, that happens to be within a query
range, I will see the Data/Get External Data/Edit Query option able to
be selected. But that is just trial and error. Thanks.