+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 15 of 16

Can't enter any data, please help.

  1. #1
    Registered User
    Join Date
    02-24-2007
    Posts
    6

    Can't enter any data, please help.

    I've been using Excel for years and had very few issues. However, I recently went into a spreadsheet to update it and was unable to select and enter data into an individual cell. When I click on a cell and try to enter #s nothing happens (my num lock is on). Then when I try to click into another cell it just highlights that cell, along with any other that I move my cursor over. Once I click on one cell I can't stop the highlighting from happening. I can't even click on anything in the toolbar. I am extremely confused, can anyone help?

  2. #2
    Valued Forum Contributor mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,983
    I have seen this happen often - especially in Excel 97

    The best method I found to fix the problem is to reboot the PC.

    I do remeber being told of another method that sometimes worked but I can not remember what it was.

  3. #3
    Registered User
    Join Date
    02-24-2007
    Posts
    6
    Thank you, but I've tried that and it didn't work. When I enter any spreadsheet it happens again and again. I have the 2000 version.

  4. #4
    Forum Contributor
    Join Date
    12-28-2006
    Location
    Germany
    MS-Off Ver
    2007
    Posts
    142
    Could you possibly have locked the sheet with protection? Try going to Tools - Protection - UnProtect Sheet. This is just a hunch. Being as you can highlight cells, but not make entries.

  5. #5
    Registered User
    Join Date
    02-24-2007
    Posts
    6
    Thanks, but I've checked that and it isn't protected. Also, it happens on any file I open in Excel.

  6. #6
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    do you have a scroll wheel on your mouse? if so, sometimes clicking that (not rolling the wheel, actually press it so it clicks) unlocks that from happening. try that. try hitting escape.

  7. #7
    Forum Contributor
    Join Date
    12-28-2006
    Location
    Germany
    MS-Off Ver
    2007
    Posts
    142
    There wasn't a final answer from Microsoft, but you can try some of these answers that I found in another post.

    http://groups.google.com/group/micro...555b291afadd30

    Chris

  8. #8
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,196
    Quote Originally Posted by namelessgrl
    I've been using Excel for years and had very few issues. However, I recently went into a spreadsheet to update it and was unable to select and enter data into an individual cell. When I click on a cell and try to enter #s nothing happens (my num lock is on). Then when I try to click into another cell it just highlights that cell, along with any other that I move my cursor over. Once I click on one cell I can't stop the highlighting from happening. I can't even click on anything in the toolbar. I am extremely confused, can anyone help?
    Hi,

    try Windows 'Start', Control Panel, Accessibility Options, and clear any ticked box in Keyboard, Mouse, Display or Sound, and in General tick only the two Notifications.

    Then start Excel.

    If the problem persists, then try, Close Excel and

    Windows 'Start' Button, select 'Run', and type
    excel /unregserver
    then
    Windows 'Start' Button, select 'Run', and type
    excel /regserver

    Search for a file *.xlb and remove it

    Search for a file Personal.xls and rename (to hide) it.

    Let me know how you go.
    ---
    Si fractum non sit, noli id reficere.

  9. #9
    Registered User
    Join Date
    02-24-2007
    Posts
    6
    Do I just go under the 'Start' and then 'Search' to look for the *.xlb file? Cause I tried that and didn't come up with any thing.

  10. #10
    Registered User
    Join Date
    02-24-2007
    Posts
    6
    I don't know if this will help in solving the problem, but when I click on a different spreadsheet within the same file my cursor becomes an arrow with a piece of paper and I can't click on anything?

  11. #11
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,196
    Quote Originally Posted by namelessgrl
    Do I just go under the 'Start' and then 'Search' to look for the *.xlb file? Cause I tried that and didn't come up with any thing.
    to Search, rightmouse the Start button and select search, as is a normal Windows Search.

    ---.

  12. #12
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,196
    Quote Originally Posted by namelessgrl
    I don't know if this will help in solving the problem, but when I click on a different spreadsheet within the same file my cursor becomes an arrow with a piece of paper and I can't click on anything?
    if you click and hold a tab this happens, make sure that your mouse button is releasing,

    ---

  13. #13
    Registered User
    Join Date
    02-24-2007
    Posts
    6
    The search didn't come up with anything and my mouse seems to be working properly. Any other suggestions?

  14. #14
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,196
    Quote Originally Posted by namelessgrl
    The search didn't come up with anything and my mouse seems to be working properly. Any other suggestions?
    yes, redo the search to a successful conclusion and try a different mouse.

    If you click on a worksheet tab and have a small down-arrow indicating position together with a sheet with an arrow then you are in the position of 'click-and-hold' that tab, you can move the sheet to left or right to re-position the sheet.

    The pc believes that you are holding the mouse button, either by some sticky-key function, bad mouse, or bad mouse driver.

    What was ticked in the 'sticky-keys' (the Accessibility) section?

    --------

    go to

    C:\Documents and Settings\HomeUser\Application Data\Microsoft\Excel

    but replace 'HomeUser' with the login name that you use.

    In there is a .xlb file

    delete that file.

    -------

    Let me know how you go.
    ---

  15. #15
    Valued Forum Contributor mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,983
    Bryan

    Your last reply about the Sticky key was the other method I could not remember in my previous reply.

+ Reply to Thread
Page 1 of 2 1 2 LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1