Recalculating problem.

[Twrchtrwyth]

I created a spreadsheet in Excel 2003 to track fat, carb, and protein
calories from various foods, then add them up. For a while, it would change
the total at the bottom of each column automatically. Then it stopped. Each
column now has to be recalculateds manually (by re-entering the formula)
every time I enter new data. Also, when I copy the formula, the cell window
shows the revised formula, but the total at the bottom is the absolute value
of the cell I was copying from--in other words, suppose the formula for n36
is =sum(n1:n35) and the total is 235. If I copy it to column p, the formula
shown is =sum(p1:p35), but the total is still 235. This is tedious and
frustrating. How can I get back to automatic recalculation?
--BTW, there's no problem in the rows, only the columns.

[Bryan Hessey]

Hi,

did you check that Tools, Options, Calculations was set to Automatic?

I created a spreadsheet in Excel 2003 to track fat, carb, and protein
calories from various foods, then add them up. For a while, it would change
the total at the bottom of each column automatically. Then it stopped. Each
column now has to be recalculateds manually (by re-entering the formula)
every time I enter new data. Also, when I copy the formula, the cell window
shows the revised formula, but the total at the bottom is the absolute value
of the cell I was copying from--in other words, suppose the formula for n36
is =sum(n1:n35) and the total is 235. If I copy it to column p, the formula
shown is =sum(p1:p35), but the total is still 235. This is tedious and
frustrating. How can I get back to automatic recalculation?
--BTW, there's no problem in the rows, only the columns.

[Twrchtrwyth]

Hi, Bryan:
Yes,
Tools>Options>Calculations is set to automatic.

"Bryan Hessey" wrote:

>
> Hi,
>
> did you check that Tools, Options, Calculations was set to Automatic?
>
>
>
> Twrchtrwyth Wrote:
> > I created a spreadsheet in Excel 2003 to track fat, carb, and protein
> > calories from various foods, then add them up. For a while, it would
> > change
> > the total at the bottom of each column automatically. Then it stopped.
> > Each
> > column now has to be recalculateds manually (by re-entering the
> > formula)
> > every time I enter new data. Also, when I copy the formula, the cell
> > window
> > shows the revised formula, but the total at the bottom is the absolute
> > value
> > of the cell I was copying from--in other words, suppose the formula for
> > n36
> > is =sum(n1:n35) and the total is 235. If I copy it to column p, the
> > formula
> > shown is =sum(p1:p35), but the total is still 235. This is tedious and
> > frustrating. How can I get back to automatic recalculation?
> > --BTW, there's no problem in the rows, only the columns.
>
>
> --
> Bryan Hessey
> ------------------------------------------------------------------------
> Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
> View this thread: http://www.excelforum.com/showthread...hreadid=399693
>
>

[Bryan Hessey]

Hi,

Sorry, but am not aware of any other reason that would do that, . . . I presume that your PC is not utilsed 100% (press CTRL/ALT/Del to bring up Windows Task Manager, and select the Performance tag to see the % used, . . . then select Processes tag and click the CPU column heading (twice?) to show in order of the high usage processes, 'Idle' should claim the highest usage)

Perhaps another has a better idea.

Hi, Bryan:
Yes,
Tools>Options>Calculations is set to automatic.

"Bryan Hessey" wrote:

>
> Hi,
>
> did you check that Tools, Options, Calculations was set to Automatic?
>
>
>
> Twrchtrwyth Wrote:
> > I created a spreadsheet in Excel 2003 to track fat, carb, and protein
> > calories from various foods, then add them up. For a while, it would
> > change
> > the total at the bottom of each column automatically. Then it stopped.
> > Each
> > column now has to be recalculateds manually (by re-entering the
> > formula)
> > every time I enter new data. Also, when I copy the formula, the cell
> > window
> > shows the revised formula, but the total at the bottom is the absolute
> > value
> > of the cell I was copying from--in other words, suppose the formula for
> > n36
> > is =sum(n1:n35) and the total is 235. If I copy it to column p, the
> > formula
> > shown is =sum(p1:p35), but the total is still 235. This is tedious and
> > frustrating. How can I get back to automatic recalculation?
> > --BTW, there's no problem in the rows, only the columns.
>
>
> --
> Bryan Hessey
> ------------------------------------------------------------------------
> Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
> View this thread: http://www.excelforum.com/showthread...hreadid=399693
>
>