Strange Excel behaviour for ONE user profile

L

Lars Hansson

We have a user who today in excel experiences that her excel acts very
strange. The return key does not work (nothing happens when hitting return)
and when she enters a number in a cell, it is divided with 100 - no matter
what format in the cell.. It is only for her user, we have a Windows
2000/2003 server AD with roaming profiles. I have resoftet her PC, installed
a newer Excel nothing works.
Any ideas about WHERE in her user profile this can be??

Regards, Lars Hansson
Oslo
 
C

Chip Pearson

Lars,

Go to the Tools menu, choose Option, then the Edit tab. There,
check the Move After Selection option and uncheck the Fixed
Decimal option.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
M

Mladen Duricic

In Excel, open Tools->Options, under edit tab, look is it "Fixed decimal"
box checked, and uncheck it. This must be resolve for divide with 100. Also
look is it "Move selection after enter" checked, if isn't check it, and
select direction "down". I believe you must do this using this user account,
and maybe, not sure, you will need to give to this account administrator
rights.
 
J

Jan Karel Pieterse

Hi Lars,
We have a user who today in excel experiences that her excel acts very
strange. The return key does not work (nothing happens when hitting return)
and when she enters a number in a cell, it is divided with 100 - no matter
what format in the cell.. It is only for her user, we have a Windows
2000/2003 server AD with roaming profiles. I have resoftet her PC, installed
a newer Excel nothing works.
Any ideas about WHERE in her user profile this can be??
Click to expand...

The divide by 100 is simple: Tools, options, Edit, uncheck "Fixed decimal"

The enter key is odd. Keyboard OK?
Maybe it is an addin or a workbook loaded at startup:

This is a default list of things-to-do when Excel exhibits (startup) problems.

Try opening Excel without any addins or hidden workbooks:

Start, Run,
"C:\Program Files\Microsoft Office\Office\Excel.exe" /Automation

Quotes mandatory, Note you may have to change the path.

If your error disappears, there is either an add-in or a (hidden) workbook
that is loaded upon XL's start, which bothers you.

- Try locating the XLSTART directory, move everything from there.
- In XL: Tools, Addins, note the ones checked and uncheck them one at the
time, each time restarting XL
- In XL, Tools, options, general. Check if a path is entered after "Alternate
startup file location". Clear it.

Another option is to open XL in Safe mode:

"C:\Program Files\Microsoft Office\Office\Excel.exe" /Safe

Also, you might try:

"C:\Program Files\Microsoft Office\Office\Excel.exe" /Regserver

Yet another possible problem is a corruption of your toolbar customisation
file. Locate all files with extension .xlb and rename the extension(s) to
something like .old
Now try and start XL again.

Also, NAV has shown to cause "Excel caused an invalid page
fault in module VBE6.DLL".
You might try disabling the Office plug in of NAV.

Other causes may be a full TEMP folder:

In Windows 95/98 and ME

Delete all files in C:\Windows\Temp

In Windows NT/2000/XP

Find and Select C:\Documents and Settings\<user>\local settings\temp
and delete all files in there.

They are often left behind by installing programs but Excel needs the space.

Excel 2003 has some new features, which may disable certain files when Excel
thought them to be the cause of a crash.

If you have had a problem with Personal.xls, Excel may have labeled it as
suspect.
In Excel, select Help | About Microsoft Excel.
Click the button near the bottom labeled "Disabled Items..."
If Personal.xls is listed, select it and click Enable.

This is what MS has to say about startup problems:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q280504

And this about startup switches:

http://support.microsoft.com/default.aspx?scid=KB;en-us;q211481


Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
L

Lars H

WOW i am really impressed with the replies here! Three replies in so short
time.. Great for an excel novice as myself :) (I am more inte OS and
security..)
I am home now but will try these things on tuesday, thanc alot to all of
you!!

Lars
 
L

Lars H

Hello! I fixed the decimal problem easily, thanx. But the "return-button"
problem is still there.. It is only OK when starting excel in safe mode, do
you have any idea why and how to solve it?
I have reformatted the pc and installed a newer excel.. problem still there,
so I am suscpecting a user profile problem here..

Lars, Oslo
 
R

RWN

Lars;
Regarding the "Return" key problem.
Check "Tools->Options->Edit" and ensure the checkbox for
"Move Selection after Enter" is checked.
 
Top