Prev: How can I regain control of a shared spreadsheet
Next: pick multiple items in data validation
From: Dave on 18 Mar 2010 10:29
Hi

I have a formula referencing a cell to give interest based on the amount in
the referenced cell. When I put a numeric value in the referenced cell the
cell with the formula does not update. When I click into and out of the cell
the formula works.

Does anyone know what this is?

Thanks
From: Pete_UK on 18 Mar 2010 11:23
You may have the calculation mode set to Manual. Click on Tools |
Options | Calculation tab (2003 menus) to set it to Automatic.

Hope this helps.

Pete

On Mar 18, 2:29 pm, Dave <D...(a)discussions.microsoft.com> wrote:
> Hi
>
> I have a formula referencing a cell to give interest based on the amount in
> the referenced cell. When I put a numeric value in the referenced cell the
> cell with the formula does not update. When I click into and out of the cell
> the formula works.
>
> Does anyone know what this is?
>
> Thanks

 | 
Pages: 1
Prev: How can I regain control of a shared spreadsheet
Next: pick multiple items in data validation