Hi,

I created 3 queries, 1 from a different workbook (FreightNew) connection only, 1 from current worksheet from a table(FreightReport) connection only and the 3rd one a merge between the previous 2 and I loaded the results to a new worksheet.

When testing updates and trying to refresh data I am receiving the errors below:

- query "Freight Exposure" was not found (although I do not have any query with such name, "Freight Exposure" is the name of the workbook and also the sheet on which I have the table named FreightReport)

- the following data range failed to refresh: ExternalData_1.

Initially my "Freight Exposure" workbook was saved as .xlsm file and I subsequently saved it as .xlsx. However the issue does not seem to be fixed.

I was wondering whether there is an easy way out, before I start re-generating all the queries from scratch.

Many thanks,

Oana