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
|
|||
|
|||
Excel 2007 will not refresh cells
Click the Office Ribbon Button(colorful round circle at the top Left
corner)Excel OptionsFormulasCalculation OptionsWorkbook CalculationSelect the AUTOMATIC Option Button and give Ok… If the above doesn’t solve your problem, then check your formula whether it’s covering new input value cell. Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "DY" wrote: I am currently using Excel 2007. I have a spreadsheet that I want to use to do some analysis of various situations. So here is my problem. I have several columns that have totals at the bottom. I have no problem getting the columns to total initially. However, if I plug in another number in the column, the total stays the same and won't refresh or re-total the column. I don't recall that this was a problem when I worked with Excel 2003. Can someone please tell me how to get the totals to update when I enter some new numbers in the column? Thanks in advance for the help. |
Thread Tools | |
Display Modes | |
|
|