Delta Star
Board Regular
- Joined
- Oct 28, 2009
- Messages
- 184
I have a large number of formula in cells D2:AA2, many use sumproduct formula which look at 10,000 rows of data.
The advice I need concerns how best to copy row 2 down to row 1000, the formula after they are copied down are converted into values.
Would it be quicker to copy the formula column by column and converting to values after each column has been done, or just continue with the mass copy that I am currently doing?
The aim is to speed up the use of the spreadsheet as each update currently takes over 30 mins to complete.
I'm turned off screen updating, but cannot turn off auto calc as many of the formula are inter linked.
The advice I need concerns how best to copy row 2 down to row 1000, the formula after they are copied down are converted into values.
Would it be quicker to copy the formula column by column and converting to values after each column has been done, or just continue with the mass copy that I am currently doing?
The aim is to speed up the use of the spreadsheet as each update currently takes over 30 mins to complete.
I'm turned off screen updating, but cannot turn off auto calc as many of the formula are inter linked.
