| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formulas not calculating
I have a bunch of worksheets where the formulas work &
I have a bunch of work sheets where the formulas are not working unless I F2 and then hit enter on the cell. I have checked tools,options, calculations & it is set to automatic. The F9 key does not work either. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formulas not calculating
How about
Ctrl+shift+F9 -- Regards, Tom Ogilvy "Wade" wrote in message ... I have a bunch of worksheets where the formulas work & I have a bunch of work sheets where the formulas are not working unless I F2 and then hit enter on the cell. I have checked tools,options, calculations & it is set to automatic. The F9 key does not work either. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formulas not calculating
Sorry Tom, That does not work
"Tom Ogilvy" wrote: How about Ctrl+shift+F9 -- Regards, Tom Ogilvy "Wade" wrote in message ... I have a bunch of worksheets where the formulas work & I have a bunch of work sheets where the formulas are not working unless I F2 and then hit enter on the cell. I have checked tools,options, calculations & it is set to automatic. The F9 key does not work either. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formulas not calculating
Hi Wade,
See if this helps http://www.mvps.org/dmcritchie/excel...a.htm#problems --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Wade" wrote in message ... Sorry Tom, That does not work "Tom Ogilvy" wrote: How about Ctrl+shift+F9 -- Regards, Tom Ogilvy "Wade" wrote in message ... I have a bunch of worksheets where the formulas work & I have a bunch of work sheets where the formulas are not working unless I F2 and then hit enter on the cell. I have checked tools,options, calculations & it is set to automatic. The F9 key does not work either. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formulas not calculating
David makes an interesting point.
do you mean the cell looks like =Formula so you see the formula instead of the result or just that the formula doesn't recalculate when you change a value it is dependent on. -- Regards, Tom Ogilvy "Wade" wrote in message ... Sorry Tom, That does not work "Tom Ogilvy" wrote: How about Ctrl+shift+F9 -- Regards, Tom Ogilvy "Wade" wrote in message ... I have a bunch of worksheets where the formulas work & I have a bunch of work sheets where the formulas are not working unless I F2 and then hit enter on the cell. I have checked tools,options, calculations & it is set to automatic. The F9 key does not work either. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formulas not calculating
the formula does not calculate, if I hit F2 & enter it works
"Tom Ogilvy" wrote: David makes an interesting point. do you mean the cell looks like =Formula so you see the formula instead of the result or just that the formula doesn't recalculate when you change a value it is dependent on. -- Regards, Tom Ogilvy "Wade" wrote in message ... Sorry Tom, That does not work "Tom Ogilvy" wrote: How about Ctrl+shift+F9 -- Regards, Tom Ogilvy "Wade" wrote in message ... I have a bunch of worksheets where the formulas work & I have a bunch of work sheets where the formulas are not working unless I F2 and then hit enter on the cell. I have checked tools,options, calculations & it is set to automatic. The F9 key does not work either. |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formulas not calculating
select a single cell, all cells or the cells that are problematic and do
Edit=Replace Replace What: = Replace With: = -- Regards, Tom Ogilvy "Wade" wrote in message ... the formula does not calculate, if I hit F2 & enter it works "Tom Ogilvy" wrote: David makes an interesting point. do you mean the cell looks like =Formula so you see the formula instead of the result or just that the formula doesn't recalculate when you change a value it is dependent on. -- Regards, Tom Ogilvy "Wade" wrote in message ... Sorry Tom, That does not work "Tom Ogilvy" wrote: How about Ctrl+shift+F9 -- Regards, Tom Ogilvy "Wade" wrote in message ... I have a bunch of worksheets where the formulas work & I have a bunch of work sheets where the formulas are not working unless I F2 and then hit enter on the cell. I have checked tools,options, calculations & it is set to automatic. The F9 key does not work either. |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formulas not calculating
I have multiple spreadsheets that when I type in a formula (i.e. =sum(k152/8)
and proceed to copy the formula into other cells - the value of k152 answer is repeated into the cells even though the formula changed to i.e =sum(k153/8). I have updated all applicable Office 2003 updates etc. and I am still having this problem, whether it's a new spreadsheet or existing one. Please help!!!!!!!!!!!!!!!!!! -- Dawn "Wade" wrote: I have a bunch of worksheets where the formulas work & I have a bunch of work sheets where the formulas are not working unless I F2 and then hit enter on the cell. I have checked tools,options, calculations & it is set to automatic. The F9 key does not work either. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas aren't calculating | Excel Discussion (Misc queries) | |||
| Formulas not calculating | Excel Discussion (Misc queries) | |||
| Not Calculating Formulas. | Excel Worksheet Functions | |||
| not calculating formulas | Excel Discussion (Misc queries) | |||
| Formulas not calculating??? | Excel Discussion (Misc queries) | |||
Hybrid Mode
