CompProbSolv
asked on
Excel 2003 oddity, works in Safe Mode
I am seeing an odd problem in Excel 2003 (on Windows XP) that I've not been able to resolve.
If you try to type the number 12 in any cell (by itself or in a formula), when you hit Enter, it changes to 14. If you put in a formula that results in 12, such as =15-3, it works fine. If you try =A12, it works fine. If you type =100/12, it changes to =100/14. I'm not seeing this with any other number. I am not seeing any other oddities in Excel, but they could well exist.
It happens on a new worksheet as well with old ones.
It does NOT happen if Excel is opened in Safe Mode (pressing Ctrl) or if I log into Windows as a different user.
I have checked or changed to the following:
Tools, Add-Ins has everything unchecked
c:\D&S\username\Applicatio n Data\Microsoft\Excel\XLSTA RT is empty
Deleted (and it recreated) C:\D&S\username\Applicatio n Data\Microsoft\Excel\Excel 11.xlb
c:\Program Files\Microsoft Office\OFFICE11\XLSTART is empty
HKCU\Software\Microsoft\Of fice\Excel \Addins only has (Default) (Value not set)
HKCU\Software\Microsoft\Of fice\11.0\ Excel\Add- in Manager only has (Default) (Value not set)
HKCU\Software\Microsoft\Of fice\11.0\ Excel\Opti ons does not have an Open key
I'm trying to avoid recreating the user in Windows, but that may be the best solution.
Any suggestions on where else to look for the offending item would be appreciated.
If you try to type the number 12 in any cell (by itself or in a formula), when you hit Enter, it changes to 14. If you put in a formula that results in 12, such as =15-3, it works fine. If you try =A12, it works fine. If you type =100/12, it changes to =100/14. I'm not seeing this with any other number. I am not seeing any other oddities in Excel, but they could well exist.
It happens on a new worksheet as well with old ones.
It does NOT happen if Excel is opened in Safe Mode (pressing Ctrl) or if I log into Windows as a different user.
I have checked or changed to the following:
Tools, Add-Ins has everything unchecked
c:\D&S\username\Applicatio
Deleted (and it recreated) C:\D&S\username\Applicatio
c:\Program Files\Microsoft Office\OFFICE11\XLSTART is empty
HKCU\Software\Microsoft\Of
HKCU\Software\Microsoft\Of
HKCU\Software\Microsoft\Of
I'm trying to avoid recreating the user in Windows, but that may be the best solution.
Any suggestions on where else to look for the offending item would be appreciated.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
As an aside, if it is an auto-correct entry, it sounds like the work of a prankster. This is standard MS Office prank material. It might be worthwhile to inquire about anyone with recent access to the user's PC.
ASKER
Thank you all for your input. I hope to have an opportunity to revisit this computer tomorrow and will post results if I do.
ASKER
Sometimes the problem is so obvious that I miss it!
mark_harris was right on the money. I found the auto-correct entry, deleted it, and all is well.
The user has no clue as to how it occurred, but will be more watchful in the future.
Thanks!
mark_harris was right on the money. I found the auto-correct entry, deleted it, and all is well.
The user has no clue as to how it occurred, but will be more watchful in the future.
Thanks!
ASKER
While the answer from mark_harris correctly identified the problem, byundt gave an excellent answer about where else to look.