Home |
Search |
Today's Posts |
#1
|
|||
|
|||
what the excell gone weird?
when I open any excel file (or create new files) it wont update any formula
unless I save the document. example cell A1 = B1 I input 2 in cell B1 cell A1 will not show the value 2 untill I save the changes. any idea what going on? Excel 2000 9.0 Thanks |
#2
|
|||
|
|||
Check Under ToolsOptionsCalculation. It sounds like it is set to Manual
with Recalculate Before Save. Select Automatic instead. Hope this helps Rowan "B.B" wrote: when I open any excel file (or create new files) it wont update any formula unless I save the document. example cell A1 = B1 I input 2 in cell B1 cell A1 will not show the value 2 untill I save the changes. any idea what going on? Excel 2000 9.0 Thanks |
#3
|
|||
|
|||
thanks found it
"Rowan" <rowanzsa at hotmailNOSPAM dot com wrote in message ... Check Under ToolsOptionsCalculation. It sounds like it is set to Manual with Recalculate Before Save. Select Automatic instead. Hope this helps Rowan "B.B" wrote: when I open any excel file (or create new files) it wont update any formula unless I save the document. example cell A1 = B1 I input 2 in cell B1 cell A1 will not show the value 2 untill I save the changes. any idea what going on? Excel 2000 9.0 Thanks |
#4
|
|||
|
|||
Check under Tools Options Calculation and Calculation set to automatic -- mudraker ------------------------------------------------------------------------ mudraker's Profile: http://www.excelforum.com/member.php...fo&userid=2473 View this thread: http://www.excelforum.com/showthread...hreadid=400321 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I view an excell document without excell (not installed wit. | Excel Discussion (Misc queries) | |||
insert query into excell sheet to update excell sheet and pivot table | Excel Discussion (Misc queries) | |||
Can I view an excell document without excell (not installed wit. | Excel Discussion (Misc queries) | |||
lable ranges in Excell | Excel Discussion (Misc queries) | |||
EXCELL 2002 Glitch???? | Excel Discussion (Misc queries) |