+ Reply to Thread
Results 1 to 7 of 7

Can't switch between worksheet tabs

  1. #1
    Registered User
    Join Date
    10-04-2010
    Location
    copenhagen
    MS-Off Ver
    Excel 2010
    Posts
    3

    Question Can't switch between worksheet tabs

    Hi

    I have a pretty huge spreadsheet with +25 worksheets tabs. My problem is that sometimes I can not switch between them when clicking on the tabs. When I click the tabs either nothing happens or I get a standard windows right click menu even though i left click (like this one, but don't mind that this it taken from the windowns menu bar, it is the same right click menu i get \1. )
    I am aware that I am able to switch between the worksheet tabs by holding ctrl and pressing PgUp or PgDn however with 25 or more sheets clicking is much much easier.

    I thought that another program could be blocking the tabs somehow, so I to a screenshot of all running processes. \1
    Can anybody help me with this annoying problem?

  2. #2
    Registered User
    Join Date
    10-04-2010
    Location
    copenhagen
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Can't switch between worksheet tabs

    Can't anyone please help me or at least point me in the direction of where i can get any help?

    Thank you and have a nice day

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Can't switch between worksheet tabs

    We might be better able to help with an example workbook not pictures
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  4. #4
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Can't switch between worksheet tabs

    I suspect either a hardware issue with the mouse, or a software (non-Excel) bug.
    Remember what the dormouse said
    Feed your head

  5. #5
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Can't switch between worksheet tabs

    Also just noticed:

    Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

    Read this to understand why we ask you to do this

  6. #6
    Registered User
    Join Date
    10-04-2010
    Location
    copenhagen
    MS-Off Ver
    Excel 2010
    Posts
    3

    Thumbs up Re: Can't switch between worksheet tabs

    @romperstomper: Sorry for not following rule 8, I honestly did not read the rules.. sorry.
    However my little forum-crime here helped me solve my problem.

    It seemed HP Wireless Assistant was causing the problem. What you need to do is to install the HotFix from HP called “HP Wireless Assistant - 3.50.11.2 (15 IV 2010) - sp48392.exe (3.8 MB)”.

    HP says that the the hotfix..:
    “Fixes an issue, which occurs when using Microsoft Excel on a notebook that
    is running a 32-bit version of the Microsoft Windows 7 Professional Operating
    System, where a pop-up menu is displayed when the Sheet1 tab at the bottom of
    the screen is clicked (instead of the tab contents being displayed). The
    displayed pop-up menu is the same as the menu you would see if you
    right-clicked the window's title bar.”


    I have not have seen the problem after installing the hotfix and can therefore with great pleasure announce that the problem has been SOLVED

    A great day to you all

  7. #7
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Can't switch between worksheet tabs

    Please make sure that you do read the forum Rules

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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