Hello,
I have a created a workbook with the same query with different views in separate worksheets. All the queries has the same variable input. The property is set to "Refresh query when opening workbook".
When I open the workbook and enter all the variables and execute, the excel workbook does not let me operate in any other window. Each time the query refreshes, the excel workbook is processed in the front, forcing me not to do any other work This way I am not able to do any other work, like writing email or so, while the workbook is executing.
Is there any setting we can change in BEx or is this a window issue.
Please exchange your inputs. I need to submit this workbook to the user soon. I dont want them to keep staring at the BEx refresh screen as the workbook keeps refreshing.
Thanks,
Rad