Excell Stops Calculating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a very large Excel file with over 75 sheets. Data is input on some sheets and processed on others to provide several reports. The problem I have, is for some reason it will stop calaulating the results. When I check a cell which has the wrong value the foumula is correct. It is simply displaying an old value that is no longer correct. For example the cell may have a formula like "=(VLOOKUP($A21,Sal!$A$7:$O$66,9)". When the value on the array changes the cell is not updated. If I modify one character of the cell's formula, hit return and then modify the change back to the original value the foumula functions properly until the next time it stops. With litterly thousands of cell in this workbook it takes a couple of days to get all of the cells functioning again. Any suggestions as to what is happening and why? and how to fix it?
 
I have noticed that Excel very "helpfully" stops calculating a big
worksheet if you click on a cell - presumbly so it does not stop you
working. (It's a feature,not a bug"??).

I suggest that you use the suggestion in the 2nd. line beneath my
signature to get this to work.
 
Make sure that you have Automatic for Calculation:
Tools, Options, Calculation, calculation: [x] Automatic

Then use the Ctrl+Alt+F9 which forces a recalculation of *everything* in
all open workbooks whether or not Excel *thinks* recalculations are needed.
http://www.mvps.org/dmcritchie/excel/shortx2k.htm#calc

You probably have very long chains of formulas dependent on previous
formulas.
 
Back
Top