I'm working with a dashboard which contains several sheets need to load huge mount of data, but I need to focus on only one sheet. So is there any way to cease other sheet's data calculation? It's really time-waste each time waiting for that.
If you opened the application with your focus-sheet no other sheets will be calculated but the application itself will need time to load all data into the RAM - therefore it could be helpful to split the application into a consolidated dashboard and a detailed report.
hi Marcus, really thanks for your reply! I just got that the other sheets will not be calculated. So I may pay attention on the optimizing of focus-sheet afterwards.
