software

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?

Toolsgt;Optiongt;Calculation, check Automatic

--
Kind regards,

Niek Otten

quot;gillydquot; gt; wrote in message
news
gt; Hi - users have been using an existing vlookup which worked well - now
gt; when
gt; they copy down the formula it retains the previous cell contents until
gt; they
gt; double click and press enter in each cell which then updates with the
gt; correct
gt; information?? Can anyone help please?
Many thanks Niek - really appreciate it!!

quot;Niek Ottenquot; wrote:

gt; Toolsgt;Optiongt;Calculation, check Automatic
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;gillydquot; gt; wrote in message
gt; news
gt; gt; Hi - users have been using an existing vlookup which worked well - now
gt; gt; when
gt; gt; they copy down the formula it retains the previous cell contents until
gt; gt; they
gt; gt; double click and press enter in each cell which then updates with the
gt; gt; correct
gt; gt; information?? Can anyone help please?
gt;
gt;
gt;