To force it to calculate, press Options and select the Calculations tab. In excel 2007 click the Office "Button" /icon, and go to Excel Options (bottom right corner).
I don't remember exactly where they moved it, but it's there somewhere.
When you click Auto Sum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers. To add the January numbers in this Entertainment budget, select cell B7, the cell immediately below the column of numbers. A formula appears in cell B7, and Excel highlights the cells you’re totaling.
Normally, if I change a value that a bar graph uses I see the bar graph change - but that does not happen with the cells that have values placed in them by the macro.
Does anyone have any suggestions for getting the cells to update? Thanks, Bobbie is[removethispart]@wrote in message news:[email protected] | Hello, | | One of our business partners is having trouble w/an Excel document.
They | have the SUM function used multiple times throughout the document, and as | they have changed values in certain fields, the SUM has automatically updated | itself to reflect this. I have tried to redo the | formulas but they simply won't work.
Here is the situation: I have a workbook that has data plugged into it manually throughout many sheets, and at the end there are a few sheets with different graphs and charts that are generated by a macro.
This macros works perfectly - all the data is accurate and the figures are perfect when compared with a manual count.