Is there any way to make it, i've tried serveral different things, but it
won't recalcuate them each time you add a number, you have to manually go
into the formula and press enter again for it to recalculate.

One quick diagnostic to try ..

Perhaps calc mode is accidentally set to manual ?

Try pressing F9, does it now compute properly?

To quickly check / change the calc mode:
Click Tools Options Calculation tab
Ensure "Automatic" is checked OK

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Chantel" wrote in message
...
Is there any way to make it, i've tried serveral different things, but it
won't recalcuate them each time you add a number, you have to manually go
into the formula and press enter again for it to recalculate.

THANK YOU SOOO MUCH, I've struggled for the past 2 days going through and
recalculating each formula, and with 20 worksheets that takes A LOT of time.
Thank you again!

"Max" wrote:

One quick diagnostic to try ..

Perhaps calc mode is accidentally set to manual ?

Try pressing F9, does it now compute properly?

To quickly check / change the calc mode:
Click Tools Options Calculation tab
Ensure "Automatic" is checked OK

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Chantel" wrote in message
...
Is there any way to make it, i've tried serveral different things, but it
won't recalcuate them each time you add a number, you have to manually go
into the formula and press enter again for it to recalculate.

Glad it helped, Chantel !
Thanks for the feedback ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Chantel" wrote in message
...
THANK YOU SOOO MUCH, I've struggled for the past 2 days going through and
recalculating each formula, and with 20 worksheets that takes A LOT of
time.
Thank you again!

gotta another question you might know, on one wkst i'm only using rows 1-284,
but when i use the scroll bar it goes all the way down to like 700 something,
i want it just so when i move the scroll bar to the bottom it only goes to my
last line...any clues?

"Max" wrote:

Glad it helped, Chantel !
Thanks for the feedback ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Chantel" wrote in message
...
THANK YOU SOOO MUCH, I've struggled for the past 2 days going through and
recalculating each formula, and with 20 worksheets that takes A LOT of
time.
Thank you again!

Try the steps outlined in Debra's page at:
http://www.contextures.com/xlfaqApp.html#Unused
"To manually reset the used range"
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Chantel" wrote in message
...
gotta another question you might know, on one wkst i'm only using rows
1-284,
but when i use the scroll bar it goes all the way down to like 700
something,
i want it just so when i move the scroll bar to the bottom it only goes to
my
last line...any clues?