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.
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 <at>yahoo<dot>com
----
"Chantel" <[email protected]> wrote in message
news:[email protected]...
> 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 <at>yahoo<dot>com
> ----
> "Chantel" <[email protected]> wrote in message
> news:[email protected]...
> > 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 <at>yahoo<dot>com
----
"Chantel" <[email protected]> wrote in message
news:[email protected]...
> 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 <at>yahoo<dot>com
> ----
> "Chantel" <[email protected]> wrote in message
> news:[email protected]...
> > 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 <at>yahoo<dot>com
----
"Chantel" <[email protected]> wrote in message
news:[email protected]...
> 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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks