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