Using paste Special in Sheet taking a lot of time

[avi21nash]

I am preparing a dashboard whose first row contains the formula which needs to be dragged down .
It takes almost 30 minutes to do a paste special .
is there any way to reduce this time .
The Sheet has 182 columns and a total of 8000 rows .
Takes almost 30 minutes daily.

 

[jmacleary]

Hi there. Not sure if this will speed it up, but try setting calculation to manual, then drag down, then set calculation back to automatic.

 

[avi21nash]

Thanks