Excel different 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

 

[JulieD]

Hi Robin

sounds strange to me ... (esp the iii ) ... can you open excel, go to help /
about microsoft excel
and retype in a post what you see in the first line in that screen.

Cheers
JulieD

 

[Robin Chapple]

I hope that this is what you meant.

Microsoft ® Excel 2002 (10.6501.6626)SP3

Cheers,

Robin

 

[JulieD]

Hi Robin

well that is what i meant but its still sounding very strange to me ... do
you have these problems in a new excel workbook or in an existing one?

if the problems are in all of your workbooks (existing & new), on the help
menu is a "detect and repair" option which you might like to run.

Cheers
JulieD

 

[Debra Dalgleish]

1) Make sure the Scroll Lock is off -- there's a key on the keyboard to
toggle it on and off

2) Perhaps your numbers are being seen as text. There are instructions
here for converting them to real numbers:

http://www.contextures.com/xlDataEntry03.html

3) Your display settings may be different on the new machine. Try
choosing a smaller DPI setting --
Right-click on the desktop and choose Properties
Select the Settings tab
Click the Advanced button
Select the General
Select a smaller setting for DPI

 

[Robin Chapple]

I have opened a new wotkbook and that will perform as SUM as normal.
The exirting worksheet will no.

 

[Robin Chapple]

My apology, The first one escaped.

I have performed the "Detect and Repair"

I have opened a new workbook and that will perform as SUM as normal.
The existing worksheet will not SUM and choosing an empty cell and
clicking the sigma icon does not produce the selection of cells that I
am used to.

Thanks for your help,

Robin

 

[JulieD]

Hi Robin

i replied to your email ... as i didn't see this post until afterwards, but
in addition to those questions did you try Debra's ideas - any luck?

how about the other programs - is Word working "normally"?

Cheers
JulieD