Skip to Content
Former Member
Apr 07, 2006 at 09:15 AM

Single Refresh in Workbook


Hi all

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.