Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Woes - Formula bug (I guess)
Problem: an excel file is being used for quite some time now (about 2
years), and it suddenly stops updating cells with formulas...for example: =SUM(c1:C10); the cell is not updated when a value is added to say... c5. Does anyone know what is happening?, I hoping that I can get my files back on track as soon as possible. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Woes - Formula bug (I guess)
Hi
First thing is to make sure that Calculation is set to Automatic. Go to Tools/Options/Calculation to make sure. Andy. "mikeydread1" wrote in message ups.com... Problem: an excel file is being used for quite some time now (about 2 years), and it suddenly stops updating cells with formulas...for example: =SUM(c1:C10); the cell is not updated when a value is added to say... c5. Does anyone know what is happening?, I hoping that I can get my files back on track as soon as possible. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Woes - Formula bug (I guess)
ToolsOptionsCalculation tab, check Automatic
-- Kind regards, Niek Otten "mikeydread1" wrote in message ups.com... | Problem: an excel file is being used for quite some time now (about 2 | years), and it suddenly stops updating cells with formulas...for | example: =SUM(c1:C10); the cell is not updated when a value is added to | say... c5. Does anyone know what is happening?, I hoping that I can get | my files back on track as soon as possible. | |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Woes - Formula bug (I guess)
Try checking your Tools-Options-Calculation and make sure that it is on Automatic. -- kraljb ------------------------------------------------------------------------ kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955 View this thread: http://www.excelforum.com/showthread...hreadid=543347 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel displaying formulae as constant and not calculating formula | Excel Worksheet Functions | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
How can i get an If formula in excel to edit another cell? | Excel Worksheet Functions | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions |