Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help, Urgent Excel Formulas are not calculating
First.. the answer is yes I have Auto Calculation's on.
I am running a macro that toggles auto calc on and off. Appartenly, I have either confused or corrupted excel. In a nut shell after the macro has run.. my formulas to not work.. very simple formulas like = A8, do not work. I can change the value in cell A8 and my root formula does not change. Unless I physically go into the cell that the formula is and manuall hit enter from the fromula window. The only global fix I have found is to save the filename as a differnt file. This seems to prompt excel to register the formulas and they update. However, this only works for that one instance. What I mean is If I simply re-open the file, without doing anything else.. the formulas are not active. I..e save and 1 time the formulas update.. if I open and type in a new result in cell A8.. the formula does not change? Please help? This is part of a huge project I have been working on at work and my deliverable is this week!!!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
display values of formulas in Excel | Excel Worksheet Functions | |||
not calculating formulas | Excel Discussion (Misc queries) | |||
Excel 2002 - copying formulas across worksheets | Excel Discussion (Misc queries) | |||
Formulas not calculating??? | Excel Discussion (Misc queries) | |||
How do I get to master Excel functions and formulas? | Excel Worksheet Functions |