No calculation on new machine

[Robin Chapple]

I run XP Home with Office 2002

I have just installed my programs to a new machine.

Excel is behaving differently on the new machine:

Observed so far:

i) I cannot select a cell by moving with the arrow keys.

ii) I can insert a calculation, SUM for instance, into a cell and I
get a 0.00 result.

iii) Format > Cells provides three options, Border, pattern and
protection. The old machine additionally gave me number, alignment and
font.

What have I miised?

Thanks,

Robin Chapple

 

[David McRitchie]

Hi Robin,
Check your status bar that you do not have SCRL on the
right side to indicate Scroll Lock (there is also a keyboard light).

Make sure that you do not have Transition navigation Shortcuts
checked in Tools, Options, Transition -- you don't want any
of those options checked.

Don't know what you have done for the last item, but
what you get is dependent on what you can enter
For instance from the formula bar the only Format you
have available is Font. Perhaps there are more protection
options in Excel 2002 than my 2000, see if you have
Tools, protection, ...anything.. turned on.

 

[Robin Chapple]

G'day David.

Hi Robin,
Check your status bar that you do not have SCRL on the
right side to indicate Scroll Lock (there is also a keyboard light).

That was correct. The cursor now moves.

Make sure that you do not have Transition navigation Shortcuts
checked in Tools, Options, Transition -- you don't want any
of those options checked.

None of those options are checked. I have now experimented and A1+A2
will add but SUM does not work.

Don't know what you have done for the last item, but
what you get is dependent on what you can enter
For instance from the formula bar the only Format you
have available is Font. Perhaps there are more protection
options in Excel 2002 than my 2000, see if you have
Tools, protection, ...anything.. turned on.

There are no protections turned on.

Many thanks so far,

Robin