For some reason formulas that I have been using often that would automatically recalculate after I had made modifications for the cells in their range are no longer doing this automatically. I have to double-click the cell so that the formula is visable and then enter to force the formula into updating. I know this shouldn't be but not sure why or what to do to fix. Please help the newb.