 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Excel Errors / April 2005the auto sum is not updating no more
everytime any1 in my office creates a spreadsheet they have to manualy selcet the auto sum square and update it manualy, i was wondering if any1 has had a similar problem and how they fixed it Not quite sure what's happening, but autosum will only work in certain circumstances 1) Contiguous data 2) Excel can workout which way you are looking to sum 3) There are clearly defined text headers That sort of thing. In truth I find autosum will only work around half the time with the many disparate way spreadsheets are built but for basic users it can be better to click and correct than need to remember the function or syntax. I suspect most intermediate to advanced users don't use it  SignatureHTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS > everytime any1 in my office creates a spreadsheet they have to manualy > selcet > the auto sum square and update it manualy, i was wondering if any1 has had > a > similar problem and how they fixed it Try Tools / Options / Calculation / Automatic Bill Manville MVP - Microsoft Excel, Oxford, England i have already checked that, it is for simple calculations, like adding up a colum or row, if we change a figure anyway where we need to the go into the autosum field and double click then hit enter, this is causeing a major mistake raate in my office, so i need to sort ito ut If you do have automatic calculation mode and the SUM is not updating when you change a value in its range then it sounds like you have a workbook with a broken calculation chain. Does Ctrl+Alt+F9 cause it to recalculate correctly? How about F9? How about Edit / Replace / = with = Which version of Excel by the way? Bill Manville MVP - Microsoft Excel, Oxford, England |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.