| 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) | |||
Linear Mode
