Chart calculations

[Anonymous]

Hi,

I have a chart problem.

In my dashboard sheet, there are 16 charts.When I change only one of them, they are all recalculating and this takes too long time.

Is there any way to stop the other chart calculations?

* I don't want them to detach, they must be attached to filters. All I need is change one chart and calculate only one that changed.

[Anonymous]

Hi ,

In Settings / Sheet Properties / Objects, you can see the time calculation of each object.

A solution could be to minimize some objects which make a lot of time to calculate or to split your tab in several small tabs.

[Anonymous]

Thanks for suggestion, but that's my plan Z