My workbook contains 3 queries. Why does it execute the queries 3 times every time? Is there a way to make execute each query once?
Keep your reports in three different sheets of your workbook or keep all in a single sheet vice-versa. Check your pre-calculation server settings.
Three queries are in 3 different sheet. Can you also guide how to change my pre calculation setting?
Precalculation server settings can be found in RSA1>Administration Tab> Monitors--> Precalculation Server
If you cannot understand the settings, you can get in touch with your BASIS team.
Login to follow, like, comment, share and bookmark content.