MrExcel Publishing
Your One Stop for Excel Tips & Solutions

formula not calculating

Posted by shane on November 13, 2001 3:57 PM

I have a formula it says ="T"ROUTERTOOLNAME That should give me a value T and then the value that ROUTERTOOLNAME looks to. For instance my value for ROUTERTOOLNAME is 12 that should make my value for my formula should say T12. IF the value for ROUTERTOOLNAME changes the formula will not show the change made until I go and click on ROUTERTOOLNAME in the formula and then enter it. It will at that point give me the new value.

Posted by Juan Pablo on November 13, 2001 4:17 PM

Don't understand...

Is ROUTERTOOLNAME a UDF ? or a Named Formula ? either way i think your formula should read

If is an UDF (But no, because of no () ), just put Application.Volatile at the begining to force recalculation.

Juan Pablo

Posted by Clay on November 13, 2001 4:59 PM

Re: Don't understand...

Let me tell you what leadto this problem we are experiencing. I was making a long formula, so long that it said "Formula too long. I tried revising it to make it shorter. It gave me that error several more times. By then I decided to go home for the night. I came back in the morning and began working in the same xls file and was experimenting with different formulas. To me it seemed that none of my formulas worked , ... but I found out that they actually were not being updated. I would write a formula to give me the Value that is in a certain cell. Teh formual would be right, but it woudl not give me theh correct number that was in the cell i told it to look at, until I would click on the formula, as if i were going to make changes to it, and hit enter. Then the formula would update and read correctly. So It seems that we are having trouble getting it to refresh on its own. I hope this helps. Any help you could provide woudl be great. Microsoft sight had nothing to help me...


Posted by Juan Pablo on November 13, 2001 5:12 PM

Re: Don't understand...

Have you checked if Calculation is set to manual ? this is the most common symptom for what you're experiencing...

Check Tools, Options, Calculation.

Juan Pablo

Posted by anno on November 13, 2001 5:15 PM

Re: Don't understand...

from what you've described it sounds like calculation may be set to manual, but like juan pablo i can't see how your formula can work at all. whatever. anyway, to set the calculation to automatic go to tools|options|calculation tab and check 'automatic' radio button.