Results 1 to 10 of 10

Excel file - can't select cells, weird issues

This is a discussion on Excel file - can't select cells, weird issues within the Excel Questions forums, part of the Question Forums category; I have a file I just received where I can't select cells and it seems like the file is trying ...

  1. #1
    Board Regular
    Join Date
    Apr 2005
    Posts
    722

    Default Excel file - can't select cells, weird issues

    I have a file I just received where I can't select cells and it seems like the file is trying to do soemthing with worksheets. Is there a way to undo setting when you first open a file without using a mouse/touchpad? I can't even use the control functions and can't figure out what is with this file.

    Thanks
    - Ryan

  2. #2
    MrExcel MVP, Administrator Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686

    Default Re: Excel file - can't select cells, weird issues

    Have you checked if the file has any macros? Is the sheet/workbook protected?

    Quote Originally Posted by rdw72777 View Post
    ...it seems like the file is trying to do soemthing with worksheets.
    Could you be a little more specific? What is happening?
    Kristy

  3. #3
    Board Regular
    Join Date
    Apr 2005
    Posts
    722

    Default Re: Excel file - can't select cells, weird issues

    So I open the file, click on a cell, and then I can't click away from that cell. It treats it as if if I'm holding ctrl shft and highlight any section that I mvoe my pointer too. I also can't select andything else, either a new sheet or any of the dropdown, nothing works. No macros.

    Something seems locked or anchored or something
    - Ryan

  4. #4
    Board Regular
    Join Date
    Apr 2005
    Posts
    722

    Default Cell freezes, workbook freezes

    I posted this earlier, and am hoping someone has a solution. I know this belongs in the Technical Issues folder there, but so far there have been no responses and there are only 2 people in that forum, versus 350 in this forum. Please if MrExcel administrators can you leave this SOS in the main Excel forum for an hour or 2 at least, I desperately need help to fix this.

    So if open or create a new file in excel, and then click in a cell, I can't click anywhere else (no other cells, no other tabs, no menu items or icons, nothing). I have tried undoing the scroll lock, but that doesn't do it. I have tried hitting SHift, Esc, Enter, F8 and nothing does anything.

    I have tried to unplug my mouse, and the touchpad has the same issue. My excel is practically useless in this format and I can't find anything on the Microsoft website to fix this. I'm normally pretty knowledgeable with Excel but this one is crazy.

    Any thoughts
    - Ryan

  5. #5
    Board Regular Diablo II's Avatar
    Join Date
    Sep 2008
    Location
    Tampa Fl
    Posts
    538

    Default Re: Cell freezes, workbook freezes

    have you tryed to put your excel **** in and use it to fix it.
    Last edited by Diablo II; Apr 6th, 2009 at 05:07 PM. Reason: did not spell excel right
    Surrender be on good terms with all persons. Speak your truth quietly & cearly; and listen to other, even the dull & ignorant, they to have their story

    TomB

  6. #6
    MrExcel MVP
    Like totally RAD man
    Colin Legg's Avatar
    Join Date
    Feb 2008
    Location
    UK
    Posts
    3,402

    Default Re: Cell freezes, workbook freezes

    lol... I'm assuming you meant disk, DiabloII, otherwise I'm not sure your suggested fix will work!
    Last edited by Colin Legg; Apr 6th, 2009 at 05:36 PM.

  7. #7
    Board Regular Diablo II's Avatar
    Join Date
    Sep 2008
    Location
    Tampa Fl
    Posts
    538

    Default Re: Cell freezes, workbook freezes

    yes i did disk, LOL , some times it will, and some time it will not but it will not hert to try.
    Surrender be on good terms with all persons. Speak your truth quietly & cearly; and listen to other, even the dull & ignorant, they to have their story

    TomB

  8. #8
    MrExcel MVP, Administrator Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686

    Default Re: Cell freezes, workbook freezes

    Have you seen the information linked in the sticky post at the top of the Technical forum?
    Unable to stop selecting cells with mouse
    Kristy

  9. #9
    Board Regular
    Join Date
    Apr 2005
    Posts
    722

    Default Re: Excel file - can't select cells, weird issues

    Kristy,

    I did see the other post you listed, and a few others. I tried following the "ghosting post that was linked to the link you sent, but it was written like an old email so I struggled to follow it.

    Assuming this is a work computer, is m best bet just to have excel removed and re-installed. I worry this will require a full MS Office re-do but don't really know for sure. I only fear it due to the time it will take, but its worth it if it can fix the problem.

    Thanks,
    - Ryan

  10. #10
    Board Regular
    Join Date
    Apr 2005
    Posts
    722

    Default Re: Excel file - can't select cells, weird issues

    Hello all,

    So a happy day is upon us (me). Basically through an "over the hils and through the woods" review, I have figured out that my mouse is the actual culprit.

    IT wnet through and tried everything and removed my mouse as a device and now using the touchpad everything works fine. The second I plug in my mouse (Logitech LX8 Laser) the problem comes back and effects botht eh mouse and touchpad. So basically, I think the mouse is somehow stuck in this funky mode and can't undo it, and I've clicked and unclicked every button on the mouse and hit the "reset" button on it too, with no luck.

    Do a mouse dies, but my computer lives. A nice tradeoff. Interesting to hear if anyone ahs suggestions on saving the mouse. For now its just going in the bottom drawer....

    Thanks for the help all!!!
    - Ryan

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com