i have a problem by saving a workbook.
I have save one with several sheets.
By refreshing, i recieve this message:"can not find the result area for the query, probably all it cells were deleted.
Please define a new area for the result.
I does i save teh woorkbook so that it works?
Bob Loyd replied
The most common cause of this error is deleting a worksheet without first removing the query that was on it.
The easiest way to resolve this problem is to add a new worksheet to your workbook, then do a refresh like before. However, this time when it prompts you to "define a new area for the result", choose anywhere on the new worksheet.
After the refresh is complete, if you want to get rid of this "orphaned" query, place your cursor in the results area for the query, then click on the Tools button on the BW toolbar and choose 'Remove Query'. After that, you can delete the empty worksheet if you like, then resave the workbook.
Hope this helps...