Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#REF! errors
Hello. When I add in a row or delete a row I get a #REF! error and instead of changing the resulting number in the sum cell, it provides the error. For example if I have a formula in cell C20 to be the sum of C12 to C19, if I remove C14, the new formula is not the sum of C12 to C19 minus C14 (as it was removed), yet rather #REF! shows up in several places, it should not.
Thanks EggHeadCafe - Software Developer Portal of Choice Play Embedded Sound Resources in .NET http://www.eggheadcafe.com/tutorials...und-resou.aspx |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
#REF! errors
It OK I figured it out. There were several links to other spreadsheets that may have been the problem. I broke the links and all is working well now.
p s wrote: #REF! errors 27-Nov-09 Hello. When I add in a row or delete a row I get a #REF! error and instead of changing the resulting number in the sum cell, it provides the error. For example if I have a formula in cell C20 to be the sum of C12 to C19, if I remove C14, the new formula is not the sum of C12 to C19 minus C14 (as it was removed), yet rather #REF! shows up in several places, it should not. Thanks Previous Posts In This Thread: EggHeadCafe - Software Developer Portal of Choice Google Search API Webservice Demo http://www.eggheadcafe.com/tutorials...i-webserv.aspx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
#DIV/0! errors | Excel Worksheet Functions | |||
Excel Throwing Circular Errors When No Errors Exist | Excel Worksheet Functions | |||
IIf and value-errors | Excel Discussion (Misc queries) | |||
sum errors | Excel Worksheet Functions | |||
Unresolved Errors in IF Statements - Errors do not show in results | Excel Worksheet Functions |