Can't switch between worksheet tabs

masmas

New Member
Joined
Oct 11, 2010
Messages
2
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 http://i33.photobucket.com/albums/d90/gQgler/IT/shift-right-click-taskbar.jpg. )
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. http://i33.photobucket.com/albums/d90/gQgler/IT/1.png
Can anybody help me with this annoying problem?
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
Welcome to the Forum,

In your workbook at the bottom left you will see the arrows to navigate to the sheets, if you use your right mouse button down there it will display all of the sheet names and you can select the one you need to go to.

I hope this helps you.
 
Upvote 0
@Trevor G: Thank you, I found my solution through you link

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
 
Upvote 0

Forum statistics

Threads
1,222,827
Messages
6,168,482
Members
452,192
Latest member
FengXue

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top