I am trying to use a file that was created in Excel 2003 in the new Excel 2010. The problem I am having is that my navigation keys work until I enter a number in a cell and press ENTER, go to a different sheet, return to the original sheet, and
type another number. When I type another number and try to press enter, the number is saved, but the cell remains highlighted and key (arrow) navigation doesn't work.
p.s. It isn't the scroll lock issue and the transitions are all disabled.
Have you tested it in Excel safe mode (i.e. Start > Run, Excel.exe /safe)?
Also please disable the macros to see if the issue can be reproduced.
If the issue persists, try creating a new workbook in Excel 2010 and then transfer the data from the original file to new file.
If there is anything I can do for you, please feel free to let me know.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.