PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Setup Formula

Reply

Formula
 
Thread Tools Rate Thread
Old 08-06-2006, 05:08 PM   #1
=?Utf-8?B?QW15?=
Guest
 
Posts: n/a
Default Formula


I am working with many excel spreadsheets that when you enter a new number in
a cell it will not update the formula cell until you save the worksheet?
Any Clue?
  Reply With Quote
Old 08-06-2006, 09:51 PM   #2
Nick Hodge
Guest
 
Posts: n/a
Default Re: Formula
Is calculation set to manual? Tools>Options...>Calculation

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"Amy" <Amy@discussions.microsoft.com> wrote in message
news:14A489B4-0250-4485-B0A8-1E3B34E2CE24@microsoft.com...
>I am working with many excel spreadsheets that when you enter a new number
>in
> a cell it will not update the formula cell until you save the worksheet?
> Any Clue?
  Reply With Quote
Old 21-06-2006, 09:35 AM   #3
=?Utf-8?B?dGh1bmRlcmJpcmQzMA==?=
Guest
 
Posts: n/a
Default Re: Formula

Thanks for your help Nick!
"Nick Hodge" wrote:

> Is calculation set to manual? Tools>Options...>Calculation
>
> --
> HTH
> Nick Hodge
> Microsoft MVP - Excel
> Southampton, England
> www.nickhodge.co.uk
> nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
>
>
> "Amy" <Amy@discussions.microsoft.com> wrote in message
> news:14A489B4-0250-4485-B0A8-1E3B34E2CE24@microsoft.com...
> >I am working with many excel spreadsheets that when you enter a new number
> >in
> > a cell it will not update the formula cell until you save the worksheet?
> > Any Clue?
>
>
>
  Reply With Quote
Reply

Archive


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off