• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formulaes not geting auto refreshed

A

Ajay Gupta

New Member
When i am copying a formula to next cell it is just taking the same value as appearing in the first formula.i.e. it is not appyling the formula in next cell but when I open the formula with F2 and press enter then it updates the formula.

Please help me to resolve this issue.
 
Ajay


Can you:


1. Post a sample formula so we can see the sue of Relative/Absolute modifiers

2. Check that calculation is set to Manual, Goto Formulas, calculation Options and check that Automatic is ticked

3. Is there any warnings in the lower left corner of the excel screen like: Circular Reference error etc?
 
Hi Hui,


I did the same thing u said in the second step.I have ticked the autmatic check box and now it is working fine now.


Thanks a lot.It was real urgent. thanks a lot.
 
You must log in or register to reply here.
Back
Top