recalculate cells

[Jeff]

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 Shafiee]

Tools -> Options -> Calculation -> Automatic

 

[Jeff]

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]

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