When you have multiple queries in multiple excel tabs it gets very slow because every change in excel leads to a query update of all queries in the sheet. it would be great if you could prevent this from happening. for instance by being able to turn off query updates separate from formula's or by a checkbox or something. Is it posilble to request features like this? and if so where?
Also when having multiple excels with queries open they all update instead of only in the sheet that is currenly used... very time consuming and slow.
maybe I overlooked a setting somewhere but any solution to fix this would be appreciated.
Another anoyance is that when you move your chosen cell through a query result table excel gets very slow with going from cell to cell. it seems this could be also prevented by a better update regime of the query or something. often leading to moving much too far instead of the cell you are looking for.
Is there any update planned to maybe fix these problems?