J
jordanctc
I have been around long enough to know better than to
start by making an accusation of finding a bug in Excel.
However, I have run into a weird behavior that is (at
least to me) quite inexplicable.
I have created a macro that moves data in rows 5 to 39 in
a block of data over one column on a monthly
spreadsheet. I leave the formulas on the last few rows
of the column to sum and whatever.
The cell in row 40 sums rows 5 to 38 of cells in the same
column (individual customer data). Row 39 an overall
total for all customers is entered manually with the
total for just listed customers in calculated in row 40.
The strange behavior is once the lady who fills out the
report fills in the cell in row 39, then suddenly the
formula in row 40 changes from a =sum(M5:M38) to =sum
(M5:M39).
So, to better test the "issue" I had her make the changes
while I watched and checked the sum formula in M40. The
formula stayed the same until she entered data in M39 and
she did not press anything else (like the Excel's prompt
about formula omitting adjacent cells).
Strange behavior to me and this is all happening on a
pretty new Dell running Win XP Pro and Office 2003 Pro.
Any help in understanding this is (as always) appreciated!
Jordan
PS. I got the file and tested it on my computer. The
formula changed when I filled in data M5 through M39 but
if I filled in M39 before all the other cells - no change.
start by making an accusation of finding a bug in Excel.
However, I have run into a weird behavior that is (at
least to me) quite inexplicable.
I have created a macro that moves data in rows 5 to 39 in
a block of data over one column on a monthly
spreadsheet. I leave the formulas on the last few rows
of the column to sum and whatever.
The cell in row 40 sums rows 5 to 38 of cells in the same
column (individual customer data). Row 39 an overall
total for all customers is entered manually with the
total for just listed customers in calculated in row 40.
The strange behavior is once the lady who fills out the
report fills in the cell in row 39, then suddenly the
formula in row 40 changes from a =sum(M5:M38) to =sum
(M5:M39).
So, to better test the "issue" I had her make the changes
while I watched and checked the sum formula in M40. The
formula stayed the same until she entered data in M39 and
she did not press anything else (like the Excel's prompt
about formula omitting adjacent cells).
Strange behavior to me and this is all happening on a
pretty new Dell running Win XP Pro and Office 2003 Pro.
Any help in understanding this is (as always) appreciated!
Jordan
PS. I got the file and tested it on my computer. The
formula changed when I filled in data M5 through M39 but
if I filled in M39 before all the other cells - no change.