Selective calculation
 

Hi all,

I have a spreadsheet with about 20 columns of data, 3 of which are
long-winded array formulas. I have some conditional formats and simple IF
functions in the other 17 columns. I would like to keep the sheet calc to
auto, but this makes entry slow because of the 3 columns of arrays. Is there
a way to exclude the array columns so I can keep the auto calc?

Thanks in advance,

SPL

Selective calculation
 

The arrays will only be recalculated if the preceding cells have changed.
If you still want to exclude them, move them to another sheet, set calculation to manual and use SHIFT+F9 (Calculate Sheet) to
calc the Active Sheet

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"PH NEWS" wrote in message ...
| Hi all,
|
| I have a spreadsheet with about 20 columns of data, 3 of which are
| long-winded array formulas. I have some conditional formats and simple IF
| functions in the other 17 columns. I would like to keep the sheet calc to
| auto, but this makes entry slow because of the 3 columns of arrays. Is there
| a way to exclude the array columns so I can keep the auto calc?
|
| Thanks in advance,
|
| SPL
|
|

Selective calculation
 

Thanks. But the preceding cells will have changed, therefore a calculation
will take place. I can't take the info to another sheet as it has to be on
view in that one and manual calculation is no good, as my conditional
formats have to appear instantly to stop the person inputting from making
mistakes. I really need to be able to keep all the info on one sheet and use
auto calc but be able to exclude certain columns.
----- Original Message -----
"Niek Otten" wrote in message
...
The arrays will only be recalculated if the preceding cells have changed.
If you still want to exclude them, move them to another sheet, set
calculation to manual and use SHIFT+F9 (Calculate Sheet) to
calc the Active Sheet

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"PH NEWS" wrote in message
...
| Hi all,
|
| I have a spreadsheet with about 20 columns of data, 3 of which are
| long-winded array formulas. I have some conditional formats and simple
IF
| functions in the other 17 columns. I would like to keep the sheet calc
to
| auto, but this makes entry slow because of the 3 columns of arrays. Is
there
| a way to exclude the array columns so I can keep the auto calc?
|
| Thanks in advance,
|
| SPL
|
|