Hi all,
I am now getting annoyed.
I had a query in another workbook, and I copied the query to a new workbook, but the table the query is linked too does not exist in the new work book. I deleted the query and created a new one, but when I put in the current.workbook formula, it brings up the query with link to the non-existent worksheet, and I looked everywhere and I cannot find a link to the workbook with that worksheet in it.
Any help please?
I am now getting annoyed.
I had a query in another workbook, and I copied the query to a new workbook, but the table the query is linked too does not exist in the new work book. I deleted the query and created a new one, but when I put in the current.workbook formula, it brings up the query with link to the non-existent worksheet, and I looked everywhere and I cannot find a link to the workbook with that worksheet in it.
Any help please?