Skip to Content
Former Member
Sep 20, 2005 at 01:59 PM

Query refresh



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

enter value.

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.