Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel not Calculating
I don't know why excel will not calculate even when I press F9 (for manual calculation). I have to end up going to the formula bar, clicking inside it and pressing enter for it to calculate. Does anybody have a reasoning and/or a way to fix this? Thanks. -- Isaac -- I Maycotte ------------------------------------------------------------------------ I Maycotte's Profile: http://www.excelforum.com/member.php...o&userid=35604 View this thread: http://www.excelforum.com/showthread...hreadid=562092 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel not Calculating
Do you have calculation set for manual?
tools|option|calculation tab Change it to automatic. I Maycotte wrote: I don't know why excel will not calculate even when I press F9 (for manual calculation). I have to end up going to the formula bar, clicking inside it and pressing enter for it to calculate. Does anybody have a reasoning and/or a way to fix this? Thanks. -- Isaac -- I Maycotte ------------------------------------------------------------------------ I Maycotte's Profile: http://www.excelforum.com/member.php...o&userid=35604 View this thread: http://www.excelforum.com/showthread...hreadid=562092 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel not Calculating
Maybe your data is not numeric?
Re-format all to General then copy an empty cell. Select the range of data and Paste SpecialAddOKEsc. Gord Dibben MS Excel MVP On Mon, 17 Jul 2006 11:06:09 -0400, I Maycotte wrote: I don't know why excel will not calculate even when I press F9 (for manual calculation). I have to end up going to the formula bar, clicking inside it and pressing enter for it to calculate. Does anybody have a reasoning and/or a way to fix this? Thanks. -- Isaac |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel file with hyperlinks takes a long time to open over the network | Links and Linking in Excel | |||
Multiple Excel versions. | Excel Discussion (Misc queries) | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
Calculating tvl time in Excel 2000 Rev.9.2720 | Excel Worksheet Functions | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |