basic problem

J

jay

in cell a1 I input an amount. In cell a2 I input formula
=(a1)......it works but cell (a2) does not change when I
change cell (a1)...why?
 
C

CalumMurdo Kennedy

Hi Jay,

If you have a very large spreadsheet with lots of calculations then it can
be handy to turn off the automatic calculations that occur everytime you
change a cell value. This can save time and stops any pauses if your
computer is not upto speed (as the x thousand formulas are updated!). To
turn this back on go to Tools, then Options and select the Calculation tab
you should see a number of options. You prob have Manual selected. If you
change this to Automatic then all of your formulas will update
automatically. This should solve your problem.

Best Regards,

CalumMurdo Kennedy
www.taekwondo.freeserve.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
VBA Coding Help for Beginner 0
VB code. If statement between two values 1
Formula to answer YES or No 4
Conditional concatenating!!! 3
Help with an if then scenario 2
copy specific cells from sheets if the information is correct 3
Hyperlink problems 1

Top