Prev: sum 2 values in diffnt cells with dup values, and sum if not dup
Next: How do I write a formula in excel where 1 = .05 and 2 = .75 etc.
From: scottmcm on 5 May 2010 11:26
when I insert a new row in my worksheet, I noticed it does not update the
formulas for any row below that line that reference another sheet in my
spreadsheet. For example, if my formula references 'sheet2'!I14 and I insert
a row above that formula it does not change the formula to 'sheet2'!I15. Is
there a way to have it where it does update the formula properly just like it
would do if I referenced a cell on the current sheet I was working on?
From: Luke M on 5 May 2010 13:44
Why would the formula need to change? You're moving the output destination,
not the input location.

--
Best Regards,

Luke M
"scottmcm" <scottmcm(a)discussions.microsoft.com> wrote in message
news:11702718-A818-4426-8D83-8235BF7C37F2(a)microsoft.com...
> when I insert a new row in my worksheet, I noticed it does not update the
> formulas for any row below that line that reference another sheet in my
> spreadsheet. For example, if my formula references 'sheet2'!I14 and I
> insert
> a row above that formula it does not change the formula to 'sheet2'!I15.
> Is
> there a way to have it where it does update the formula properly just like
> it
> would do if I referenced a cell on the current sheet I was working on?


 | 
Pages: 1
Prev: sum 2 values in diffnt cells with dup values, and sum if not dup
Next: How do I write a formula in excel where 1 = .05 and 2 = .75 etc.