Excel is not updating formulas
Based on this information, formulas in other cells calculate costs and time. Anyone experience this before and is there a quick fix? Specifically, the code you suggested goes in the code list for the actual sheet and the code I posted goes in a module.Not immediately logical to me, but I think I understand it now. Then re-calculate the formula in the cell by double clicking on the cell and pressing Enter.When typing the formula be sure not to enter a space before the equals.There are 5 reasons for your Excel formula not calculating are many. The first thing that you should check is that the calculation options are not set to manual. Click the Formulas tab and then the Calculation Options button.If this is set to manual, the formulas will not update unless you press the Calculate Now or Calculate Sheet buttons.
You might get away with pressing F9 to calculate Regards, TMS Trevor Shuttleworth - Excel Aid I dream of a better world where chickens can cross the road without having their motives questioned 'Being unapologetic means never having to say you're sorry' John Cooper Clarke You can probably call the function on a Selection_Change event.. Volatile might not work because the sheet does not re-calculate when the color is applied..Selection_Change might be the only way I know where you will have to click somewhere else once for the code to get triggered...I would suggest using a different method to flag and count cells.(I only discovered this after an hour of tinkering, figuring I had botched the formula!) Are there any ways around this so that it updates upon dragging the formula?