#1
|
|||
|
|||
Sum not calculating automatically
I have a macro spreadsheet, that has started to not recalculate the sum when data is altered.
The sheet is set for automatic calculation and the setting for automatic calculations are in place. But when data is changes the =SUM formula does not alter unless the cell is edited by using Function F2 which then changes the total to the correct new number? What is the corruption and how can it be rectified? |
#2
|
|||
|
|||
Looks like text string is copied into cell formatted as General by VBA code!
When you have a numeric value entered into cell as string, it remains string until the cell is edited. Copying string value directly or by code into worksheet doesn't fire calculation event. An example: Format column A as Text. Into range A1:A3 enter values 1,2,3; Into cell C1 enter the formula =SUM(A1:A3). The result will be 0; Format column A as General. The result remains 0; Edit range A1:A3 (select the range and press F2 and enter 3 times, or emter the number 1 elsewhere, copy the cell with entered 1, and use PasteSpecial>Multiply on range A1:A3). The result will be 6. |
Tags |
automatic document, sum |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
automatically calculating employee utilization | makaveli80 | Excel | 7 | 03-08-2018 03:46 PM |
all of my formulas quit automatically calculating | chenstrap | Excel | 4 | 03-16-2016 08:04 AM |
earned value not calculating | ketanco | Project | 3 | 08-16-2012 02:13 PM |
Calculating earned value | ketanco | Project | 3 | 08-13-2012 09:06 AM |
calculating duration | ketanco | Project | 5 | 12-15-2011 07:15 PM |