vlookup: I have to double click each cell to get correct results?

Hi - users have been using an existing vlookup which worked well - now when
they copy down the formula it retains the previous cell contents until they
double click and press enter in each cell which then updates with the correct
information?? Can anyone help please?

Tools>Option>Calculation, check Automatic

--
Kind regards,

Niek Otten

"gillyd" <[email protected]> wrote in message
news:[email protected]...
> Hi - users have been using an existing vlookup which worked well - now
> when
> they copy down the formula it retains the previous cell contents until
> they
> double click and press enter in each cell which then updates with the
> correct
> information?? Can anyone help please?

Many thanks Niek - really appreciate it!!

"Niek Otten" wrote:

> Tools>Option>Calculation, check Automatic
>
> --
> Kind regards,
>
> Niek Otten
>
> "gillyd" <[email protected]> wrote in message
> news:[email protected]...
> > Hi - users have been using an existing vlookup which worked well - now
> > when
> > they copy down the formula it retains the previous cell contents until
> > they
> > double click and press enter in each cell which then updates with the
> > correct
> > information?? Can anyone help please?
>
>
>