I have an workbook with 2 queries on 2 sheets.
I would like save the workbook without results.
If i open the workbook the result area is blank.
I have created a button on every sheet to refresh the query (result area). This works good.
Furthermore i have a dropdown box on every sheet.
If i select the dropdown box and sheet2 is still blank, the BEx Analyzer refresh sheet2 at first.
How can i write the code that sheet2 will not be refrehed.