Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Array functions that I wan to update only on command
Hi,
I have a workbook with a lot of functions. One array function gathers data from one column, but the column is quite large (can not be made smaller) so every time I write just one new value it takes 20 minutes for the sheet to update itself. Is it possible to have the update only by demand, say a button, so all values can be added before starting the time consuming process of trasfering the values. Thanks in advance! Lii Hadin |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Array functions that I wan to update only on command
Have you tried Tools/Options/Calculation/Manual? Then use F9 when you want
to calculate? Will "Lii Hadin" wrote: Hi, I have a workbook with a lot of functions. One array function gathers data from one column, but the column is quite large (can not be made smaller) so every time I write just one new value it takes 20 minutes for the sheet to update itself. Is it possible to have the update only by demand, say a button, so all values can be added before starting the time consuming process of trasfering the values. Thanks in advance! Lii Hadin |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Array functions that I wan to update only on command
Worked fine, thanks!
"roadkill" skrev: Have you tried Tools/Options/Calculation/Manual? Then use F9 when you want to calculate? Will "Lii Hadin" wrote: Hi, I have a workbook with a lot of functions. One array function gathers data from one column, but the column is quite large (can not be made smaller) so every time I write just one new value it takes 20 minutes for the sheet to update itself. Is it possible to have the update only by demand, say a button, so all values can be added before starting the time consuming process of trasfering the values. Thanks in advance! Lii Hadin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array functions | Excel Worksheet Functions | |||
can an array update only once? | Excel Worksheet Functions | |||
array functions | Excel Worksheet Functions | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
Array functions | Excel Discussion (Misc queries) |