If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel calculation problem
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. |
#2
|
|||
|
|||
Excel calculation problem
Are you in manual calculation mode? (try hitting F9)
-- Best Regards, Luke M "scarmalt" wrote in message ... 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. |
#3
|
|||
|
|||
Excel calculation problem
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. |
Thread Tools | |
Display Modes | |
|
|