Prev: import color scheme from another excel (2007)
Next: Excel Text Formula
From: scarmalt on 4 Jun 2010 08:07
I think something in Excel 2007 is trying to be too clever by half (or is it
a bug?).

Col A Formula Result Expected
2.25 =a$1 2.25 2.25
2.25 =a$1 + a2 4.50 4.50
3.50 =SUM(a$1:a3) 8.00 8.00
1.75 =SUM(a$1:a4) 8.00 9.75
2.00 =SUM(a$1:a5) 8.00 11.75
5.25 =SUM(a$1:a6) 8.00 17.00
9.00 =SUM(a$1:a7) 8.00 26.00
8.25 =SUM(a$1:a8) 8.00 34.25

The formula in cells B4:B8 was copied from B3. While inspection of the
formula indicates the correct change of row (as shown above), the calculation
doesn't reflect it (it acts as though the formula is =SUM(a$1:a$3). The
calculation is correct if I enter the formula specifically into each cell,
but my real situation calls for hundreds of cells, so I want the copy to
work. Thanks for any help.

From: Luke M on 4 Jun 2010 08:18
Are you in manual calculation mode? (try hitting F9)

--
Best Regards,

Luke M
"scarmalt" <scarmalt(a)discussions.microsoft.com> wrote in message
news:05E48CE8-B01E-457F-ABED-CFDCF30A7992(a)microsoft.com...
>I think something in Excel 2007 is trying to be too clever by half (or is
>it
> a bug?).
>
> Col A Formula Result Expected
> 2.25 =a$1 2.25 2.25
> 2.25 =a$1 + a2 4.50 4.50
> 3.50 =SUM(a$1:a3) 8.00 8.00
> 1.75 =SUM(a$1:a4) 8.00 9.75
> 2.00 =SUM(a$1:a5) 8.00 11.75
> 5.25 =SUM(a$1:a6) 8.00 17.00
> 9.00 =SUM(a$1:a7) 8.00 26.00
> 8.25 =SUM(a$1:a8) 8.00 34.25
>
> The formula in cells B4:B8 was copied from B3. While inspection of the
> formula indicates the correct change of row (as shown above), the
> calculation
> doesn't reflect it (it acts as though the formula is =SUM(a$1:a$3). The
> calculation is correct if I enter the formula specifically into each cell,
> but my real situation calls for hundreds of cells, so I want the copy to
> work. Thanks for any help.
>


From: Gary Brown on 4 Jun 2010 08:45
It looks like you have Calculation set to 'Manual'.
TOOLS > OPTIONS > CALCULATION > AUTOMATIC
Then hit the F9 key just to make sure the worksheet calculates.
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"scarmalt" wrote:

> I think something in Excel 2007 is trying to be too clever by half (or is it
> a bug?).
>
> Col A Formula Result Expected
> 2.25 =a$1 2.25 2.25
> 2.25 =a$1 + a2 4.50 4.50
> 3.50 =SUM(a$1:a3) 8.00 8.00
> 1.75 =SUM(a$1:a4) 8.00 9.75
> 2.00 =SUM(a$1:a5) 8.00 11.75
> 5.25 =SUM(a$1:a6) 8.00 17.00
> 9.00 =SUM(a$1:a7) 8.00 26.00
> 8.25 =SUM(a$1:a8) 8.00 34.25
>
> The formula in cells B4:B8 was copied from B3. While inspection of the
> formula indicates the correct change of row (as shown above), the calculation
> doesn't reflect it (it acts as though the formula is =SUM(a$1:a$3). The
> calculation is correct if I enter the formula specifically into each cell,
> but my real situation calls for hundreds of cells, so I want the copy to
> work. Thanks for any help.
>
 | 
Pages: 1
Prev: import color scheme from another excel (2007)
Next: Excel Text Formula