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" <[email protected]> wrote in message
news:[email protected]...
> 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

[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" wrote:

> Tools -> Options -> Calculation -> Automatic
>
> "Jeff" <[email protected]> wrote in message
> news:[email protected]...
> > 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]

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