Array functions that I wan to update only on command

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Have you tried Tools/Options/Calculation/Manual? Then use F9 when you want
to calculate?
Will
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining arrays for a Lookup function 5
INDEX function array causes problem when attempting to use LARGEfunction to sort positive and negati 10
XL2000 Array Function Problem 2
Networkday & workday with array functions 1
want to track time while paste value in multiple column of same roe 1
Excel Trying to do a vlookup with a nested right function on the array 3
Replacing a data range in a nested array function 1
using CountIF function or Array? 3

Back
Top