Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 doesnt solve your problem, then check your formula whether its 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 and refresh pivot table methodology | New Users to Excel | |||
EXCEL 2007 CHART REFRESH WHILE MACRO IS RUNNING | Charts and Charting in Excel | |||
how do I refresh in excel 2007 a 2003 pivot table? | Excel Discussion (Misc queries) | |||
Pivot Chart won't refresh in Excel 2007 | Charts and Charting in Excel | |||
Excel 2007 Refresh Pivot Table | Excel Discussion (Misc queries) |