i get the following error when i refresh a workbook which has 6 queries.
Cannot find the results area for a query, probably all its cells were deleted. please define a new location for the results area.
and then when i click ok in the window.
new window pops up: Repair results areas
this happen only when i refresh all of the workbook i tried refreshing each query in the workbook seperately n i dont get this message can someone please tell me how to solve this.