| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I have a delay in formula results when I change one cell amount
If I autosum A1:a6 and get an answer, then change A3 cell value, I don't get
the corrected autosum until I save the file. Why the delay in results? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I have a delay in formula results when I change one cell amount
do you have tools-options-calculations set to automatic
"JStangl" wrote: If I autosum A1:a6 and get an answer, then change A3 cell value, I don't get the corrected autosum until I save the file. Why the delay in results? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I have a delay in formula results when I change one cell amoun
Yes it is set to automatic and still have the delay.
"bj" wrote: do you have tools-options-calculations set to automatic "JStangl" wrote: If I autosum A1:a6 and get an answer, then change A3 cell value, I don't get the corrected autosum until I save the file. Why the delay in results? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I have a delay in formula results when I change one cell amount
Tools/ Options/ Calculation. Change from Manual to Automatic.
-- David Biddulph "JStangl" wrote in message ... If I autosum A1:a6 and get an answer, then change A3 cell value, I don't get the corrected autosum until I save the file. Why the delay in results? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I have a delay in formula results when I change one cell amoun
As I said earlier, it is set to automatic and I still have the delay.
"David Biddulph" wrote: Tools/ Options/ Calculation. Change from Manual to Automatic. -- David Biddulph "JStangl" wrote in message ... If I autosum A1:a6 and get an answer, then change A3 cell value, I don't get the corrected autosum until I save the file. Why the delay in results? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I have a delay in formula results when I change one cell amoun
Earlier?
The entire content of the message to which I was replying was as follows: "If I autosum A1:a6 and get an answer, then change A3 cell value, I don't get the corrected autosum until I save the file. Why the delay in results?" It has no reference, either in the text or in the message header, to any previous message. If your question was intended to refer to some previous message, it would have been wise to have continued in the same thread, and quoted the relevant context in your new message. Where is this earlier message? -- David Biddulph "JStangl" wrote in message ... As I said earlier, it is set to automatic and I still have the delay. "David Biddulph" wrote: Tools/ Options/ Calculation. Change from Manual to Automatic. -- David Biddulph "JStangl" wrote in message ... If I autosum A1:a6 and get an answer, then change A3 cell value, I don't get the corrected autosum until I save the file. Why the delay in results? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I have a delay in formula results when I change one cell amoun
Sorry, I now see that you had posted a reply to bj 8 minutes before my
original reply to you, and 56 minutes before my subsequent reply. Unfortunately, messages don't propagate immediately between servers, and in particular there are often substantial delays in messages to and from Microsoft's rather flaky web interface with the newsgroup, so your message had neither reached my news server nor the Google archive. The message is there now, and I have no idea why you've got the delay in your calculations. -- David Biddulph "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Earlier? The entire content of the message to which I was replying was as follows: "If I autosum A1:a6 and get an answer, then change A3 cell value, I don't get the corrected autosum until I save the file. Why the delay in results?" It has no reference, either in the text or in the message header, to any previous message. If your question was intended to refer to some previous message, it would have been wise to have continued in the same thread, and quoted the relevant context in your new message. Where is this earlier message? -- David Biddulph "JStangl" wrote in message ... As I said earlier, it is set to automatic and I still have the delay. "David Biddulph" wrote: Tools/ Options/ Calculation. Change from Manual to Automatic. -- David Biddulph "JStangl" wrote in message ... If I autosum A1:a6 and get an answer, then change A3 cell value, I don't get the corrected autosum until I save the file. Why the delay in results? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I have a delay in formula results when I change one cell amoun
In article ,
"David Biddulph" <groups [at] biddulph.org.uk wrote: so your message had neither reached my news server Since you're using OE, you could connect directly to the MS news server: http://www.mvps.org/dmcritchie/ie/oe6nws01.htm |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I have a delay in formula results when I change one cell amoun
I can't from here, as we can connect only to the company's internal servers,
but I can at home. That's why I checked the Google archive as well as the server. -- David Biddulph "JE McGimpsey" wrote in message ... In article , "David Biddulph" <groups [at] biddulph.org.uk wrote: so your message had neither reached my news server Since you're using OE, you could connect directly to the MS news server: http://www.mvps.org/dmcritchie/ie/oe6nws01.htm |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I have a delay in formula results when I change one cell amoun
In article ,
"David Biddulph" <groups [at] biddulph.org.uk wrote: I can't from here, as we can connect only to the company's internal servers Ah, too bad |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I have a delay in formula results when I change one cell amoun
a circular reference can do that
"JE McGimpsey" wrote: In article , "David Biddulph" <groups [at] biddulph.org.uk wrote: I can't from here, as we can connect only to the company's internal servers Ah, too bad |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change amount in figure to amount in words? | Excel Worksheet Functions | |||
| IF function comare to identical amount but inconsistent results | Excel Worksheet Functions | |||
| Formula for amount owing subtract amount paid | Excel Worksheet Functions | |||
| How do I change formula results by changing the text color of the | Excel Discussion (Misc queries) | |||
| Formula results in font color change | Excel Worksheet Functions | |||
Linear Mode
