If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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!!!!! |
#2
|
|||
|
|||
It is possible that whatever else your macro is doing it is also re-formatting
the formula cells to Text. By going into the cell and hitting ENTER you are re-re-formatting back to General Format and the formulas work. Either re-write the macro or add a find and replace to it. Select all formula cells and EditReplace What: = With: = Replace All and your formulas will calculate properly. Gord Dibben Excel MVP On Mon, 2 May 2005 15:52:04 -0700, "maashoff" wrote: 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 | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
AGE CALCULATING EXCEL SPREADSHEETS AND OTHERS! | RICHARD | General Discussion | 0 | March 1st, 2005 01:53 PM |
Coverting Lotus 123 files to use with excel | Muffin1947 | General Discussion | 6 | June 20th, 2004 10:18 AM |
Problems using Excel 97 worksheet in Excel 2002 | plfoley | Worksheet Functions | 1 | May 2nd, 2004 09:54 AM |
Pointer-like behaviour in Excel possible to build formulas? | Kris Coverdale | Worksheet Functions | 7 | January 14th, 2004 04:10 PM |
Excel formulas | Tina | Worksheet Functions | 1 | November 13th, 2003 08:18 AM |