recalculate cells
 

Hi,
My spreadsheet does the following:
1) I have 3 arrays in 3 columns.
2) it looks up the "LAST" element of each array and return its name (1st row
of each column) the value is displayed on D1.
3) E1, and E2 are string munipulation of D1.

Problem I have:
it doesn't update all the cells automatically, sometimes i even have to hit
F9 several times to make sure it's been fully recalculated. Is it a way I
can fix that problem?

Thanks

Tools - Options - Calculation - Automatic

"Jeff" wrote in message
...
Hi,
My spreadsheet does the following:
1) I have 3 arrays in 3 columns.
2) it looks up the "LAST" element of each array and return its name (1st
row
of each column) the value is displayed on D1.
3) E1, and E2 are string munipulation of D1.

Problem I have:
it doesn't update all the cells automatically, sometimes i even have to
hit
F9 several times to make sure it's been fully recalculated. Is it a way I
can fix that problem?

Thanks

Mohamed,
I know that would work, I am using a 3rd party add-in... which puts down
live data from some server every few minute or so... with calculation sets to
automatic, i won't be able to do anything at all (since it'll be updating
pretty much all the cells). Is it a way to select it to update certain cells
before others?


Jeff

"Mohamed Shafiee" wrote:

Tools - Options - Calculation - Automatic

"Jeff" wrote in message
...
Hi,
My spreadsheet does the following:
1) I have 3 arrays in 3 columns.
2) it looks up the "LAST" element of each array and return its name (1st
row
of each column) the value is displayed on D1.
3) E1, and E2 are string munipulation of D1.

Problem I have:
it doesn't update all the cells automatically, sometimes i even have to
hit
F9 several times to make sure it's been fully recalculated. Is it a way I
can fix that problem?

Thanks

Third party add-in huh...
What kind of data are you talking about? Sounds very interesting.