Microsoft Office Forums Sum not calculating automatically

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-15-2019, 02:06 AM
Mark Turner Mark Turner is offline Sum not calculating automatically Windows 10 Sum not calculating automatically Office 2010
Novice
Sum not calculating automatically
 
Join Date: Oct 2019
Posts: 1
Mark Turner is on a distinguished road
Default 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?
Reply With Quote
  #2  
Old 10-15-2019, 03:02 AM
ArviLaanemets ArviLaanemets is offline Sum not calculating automatically Windows 8 Sum not calculating automatically Office 2016
Expert
 
Join Date: May 2017
Posts: 492
ArviLaanemets has a spectacular aura aboutArviLaanemets has a spectacular aura about
Default

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.
Reply With Quote
Reply

Tags
automatic document, sum

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sum not calculating automatically automatically calculating employee utilization makaveli80 Excel 7 03-08-2018 03:46 PM
Sum not calculating automatically 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
Sum not calculating automatically Calculating earned value ketanco Project 3 08-13-2012 09:06 AM
Sum not calculating automatically calculating duration ketanco Project 5 12-15-2011 07:15 PM


All times are GMT -7. The time now is 09:35 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft