Excel: Formula worked last week but now stoppped working.
 

Excel: Formula worked last week but now stoppped working.
I have too many calculations to redo them. XPspk2 might have been installed
since last week.
Jo :)

Hi
what do you mean exactly with 'does not work anymore'

--
Regards
Frank Kabel
Frankfurt, Germany

"User" schrieb im Newsbeitrag
...
Excel: Formula worked last week but now stoppped working.
I have too many calculations to redo them. XPspk2 might have been
installed
since last week.
Jo :)

A tad more detail might just be in order here. :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"User" wrote in message
...
Excel: Formula worked last week but now stoppped working.
I have too many calculations to redo them. XPspk2 might have been installed
since last week.
Jo :)



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.809 / Virus Database: 551 - Release Date: 09/12/2004

Sorry. Yeh I know you need more detail.

I have about 140 numbers in a colum from D5 to D145. At the bottom there is
a total, adding the cells in the colum together. When I change lets say cell
D50's number in it, the total at the end must also change reflecting the
number that was changed in this cell. Now when I change any cell in the
colum's value, the total stays the same.

I treid re-installing, repairing & redoing the formula...no luck. By the
way: When I open a new worksheet and do formulas in it, all is well in that
sheet.

Seems like only the recent(last week or so) work is effected?

Hope this makes sence...?

Jo



"Frank Kabel" wrote in message
...
Hi
what do you mean exactly with 'does not work anymore'

--
Regards
Frank Kabel
Frankfurt, Germany

"User" schrieb im Newsbeitrag
...
Excel: Formula worked last week but now stoppped working.
I have too many calculations to redo them. XPspk2 might have been
installed
since last week.
Jo :)

Tools / Options / Calculation Tab / Tick Automatic as opposed to Manual

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"User" wrote in message
...
Sorry. Yeh I know you need more detail.

I have about 140 numbers in a colum from D5 to D145. At the bottom there is a
total, adding the cells in the colum together. When I change lets say cell
D50's number in it, the total at the end must also change reflecting the
number that was changed in this cell. Now when I change any cell in the
colum's value, the total stays the same.

I treid re-installing, repairing & redoing the formula...no luck. By the way:
When I open a new worksheet and do formulas in it, all is well in that sheet.

Seems like only the recent(last week or so) work is effected?

Hope this makes sence...?

Jo



"Frank Kabel" wrote in message
...
Hi
what do you mean exactly with 'does not work anymore'

--
Regards
Frank Kabel
Frankfurt, Germany

"User" schrieb im Newsbeitrag
...
Excel: Formula worked last week but now stoppped working.
I have too many calculations to redo them. XPspk2 might have been
installed
since last week.
Jo :)







---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.809 / Virus Database: 551 - Release Date: 09/12/2004

Hi Jo

Anything change when you press F8 ? If so then calculation is turned off.
Reset it in the Tools Options menu.

HTH. Best wishes Harald

"User" skrev i melding
...
Sorry. Yeh I know you need more detail.

I have about 140 numbers in a colum from D5 to D145. At the bottom there
is
a total, adding the cells in the colum together. When I change lets say
cell
D50's number in it, the total at the end must also change reflecting the
number that was changed in this cell. Now when I change any cell in the
colum's value, the total stays the same.

Hi
goto 'Tools - Options - Calculate' and check 'Automatic Calculation'

--
Regards
Frank Kabel
Frankfurt, Germany

"User" schrieb im Newsbeitrag
...
Sorry. Yeh I know you need more detail.

I have about 140 numbers in a colum from D5 to D145. At the bottom
there is
a total, adding the cells in the colum together. When I change lets
say cell
D50's number in it, the total at the end must also change reflecting
the
number that was changed in this cell. Now when I change any cell in
the
colum's value, the total stays the same.

I treid re-installing, repairing & redoing the formula...no luck. By
the
way: When I open a new worksheet and do formulas in it, all is well
in that
sheet.

Seems like only the recent(last week or so) work is effected?

Hope this makes sence...?

Jo



"Frank Kabel" wrote in message
...
Hi
what do you mean exactly with 'does not work anymore'

--
Regards
Frank Kabel
Frankfurt, Germany

"User" schrieb im Newsbeitrag
...
Excel: Formula worked last week but now stoppped working.
I have too many calculations to redo them. XPspk2 might have been
installed
since last week.
Jo :)

Anything change when you press F8 ?

Think Harald meant F9, not F8 key <g
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

"Max" skrev i melding
...
Anything change when you press F8 ?

Think Harald meant F9, not F8 key <g

Typo, sorry. Thanks for the correction Max.

Best wishes Harald