| 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
Thanks for the sentiment, but
There would be too many typos and they would probably want Dave Peterson to Review it. Yikes! -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... 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. |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formulas not calculating
Oops, wrong thread - disregard.
-- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... Thanks for the sentiment, but There would be too many typos and they would probably want Dave Peterson to Review it. Yikes! -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... 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. |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formulas not calculating
i'm glad i'm not the only one that does that<g
-- Gary "Tom Ogilvy" wrote in message ... Oops, wrong thread - disregard. -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... Thanks for the sentiment, but There would be too many typos and they would probably want Dave Peterson to Review it. Yikes! -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... 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. |
|
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formulas not calculating
This can't be good--'cause we know he doesn't open attachments!
Tom Ogilvy wrote: Thanks for the sentiment, but There would be too many typos and they would probably want Dave Peterson to Review it. Yikes! -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... 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. ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? -- Dave Peterson |
|
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formulas not calculating
Tom,
I had the same issue. This fix works. Thanks. Any idea why it works and none of the methods to explicitly force calculation work? - Steve "Tom Ogilvy" wrote: 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. |
|
#13
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) | |||
Linear Mode
