» 
Excel
Okay I'm having a totally weird problem in Exel. I have a formual in a cell that is based on calling other cells. I'll use the totaly simplified example of '=A3+1' and let's say this is in cell B3. Now normally when I select a vertical range and fill down it it changes the fomrula to '=A4+1' in cell B4. This is what I want it to do and it works perfectly. Just now, and twice yesterday, I used the fill down command and it properly fills down the formula in the formula bar but doesn't update the display to reflect that. If I highlight each cell, select the formula bar and hit enter it updates it with no further editing on my part but that is a pain. Is there some option in excel that accidently got turned on/off? Keep in mind all of the formula are right, the output on screen is just worng, and it's wrong when I print it.
|