User with AutoSum problems

[craziefro]

I have a user that is having problems with AutoSum updating after a cell is deleted. He has the following...

100
200
100

400

If he deletes one of the cells, (lets say 200), the autosum number stays at 400. I reinstalled his MS Office and it worked for a few days, but now he is having the same problem.

So now he has...
100

100

400

Any suggestions would be greatly appreciated, as this "user" is my boss.

[Bryan Hessey]

I have a user that is having problems with AutoSum updating after a cell is deleted. He has the following...

100
200
100

400

If he deletes one of the cells, (lets say 200), the autosum number stays at 400. I reinstalled his MS Office and it worked for a few days, but now he is having the same problem.

So now he has...
100

100

400

Any suggestions would be greatly appreciated, as this "user" is my boss.

Hi,

first guess is 'Press F9'

then check Tools, Options, Calculate and set to Automatic.

hth
---

[craziefro]

Will "Calculate Now" F9 do calculations for the entire worksheet, or just the particular cell you are in.

Thanks

[Bryan Hessey]

Will "Calculate Now" F9 do calculations for the entire worksheet, or just the particular cell you are in.

Thanks

the worksheet, to calculate just the cell re-enter the formula

---

[craziefro]

My user is still having problems, it is intermittent. I did a reinstall. Any other clues?

[Bryan Hessey]

My user is still having problems, it is intermittent. I did a reinstall. Any other clues?

Hi,

when the user has problems is the 'Automatic' set, or does this keep un-setting itsself?

---

[craziefro]

I am not sure, I have told him to check to see if it unsets it self. Once I know perhaps then we will know the route to pursue.

[Bryan Hessey]

I am not sure, I have told him to check to see if it unsets it self. Once I know perhaps then we will know the route to pursue.

it should help, yes.

Perhaps we can discover what the user is doing to cause this.

If the user does not use Personal.xls this should be deleted (search for it)
also, the *.xlb file can also be deleted. (both with Excel closed).

---

[craziefro]

it should help, yes.

Perhaps we can discover what the user is doing to cause this.

If the user does not use Personal.xls this should be deleted (search for it)
also, the *.xlb file can also be deleted. (both with Excel closed).

---

Bryan,
What are these files used for?

[Bryan Hessey]

Bryan,
What are these files used for?

the .xlb is Excel's 'default', and will be re-created when you start excel.

Personal.xls saves your personal items, macros etc, used by some but I always delete mine if one is created.

If the user is not aware of Personal.xls then rename it or delete it.
If the user uses Personal.xls (which I doubt in this case) then rename it for a test, and replace it after the test.

---