Excel 2007 worksheet switching issue using Windows 7

[mrjroz]

Has anyone experienced an issue with the ability to fluently switch between
worsheets in an Excel 2007 Workbook? I noticed that it would often take
several mouse clicks on a Tab before the worksheet finally switched. Once it
does, it is fluent for a short time and then hangs up again. The cycle
repeats.

Any suggestions that will help this, shy of a patch or waiting for MSO 2010?

 

[ethanolson]

I have the same issue. It brings up the master explorer program menu
(Restore, Move, Size, Minimize, Maximize, Close). Bugs me a lot.

 

[Simon Murphy]

Do you have any add-ins loaded that are using the sheet
activate/deactivate event to do a bunch of work?

Does it only happen in Win 7?

Cheers
Simon
Excel development website: www.codematic.net

 

[Mike the student]

Just upgraded to Win 7 and quickly discovered this "feature." Same as the
others: hard to switch worksheets; often the master explorer menu pops up. I
better not have to upgrade just to get rid of this error...

 

[Mike the student]

Workaround for now: CTRL + PG DOWN (or PG UP) will move to worksheet to left
or right... You have to have a cell in the worksheet selected.

For the record, I have Win 7 64 bit.

 

[Stefan Blaser]

I've the same problem. Any solutions out there?

Stefan

 

[Jan Karel Pieterse]

Hi Stefan,

I've the same problem. Any solutions out there?

Check your add/remove programs and ensure "Updates" is checked. Uninstall Excel
update KB973593 (updated in november 2009 if I recall correctly) if it is
there.

Does that fix the problem?

If so, please call 1-866-pcSafety for free, to report issues with this security
update.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

 

[Jiri Koudelka]

We've exactly the same problem on PCs with Windows Vista and W7 both x64. We
don’t use any macros, any add-ins in Excel 2007. I checked Updates and
KB973593 is not installed.
How shall we fix the issue?
Thanks a lot.
Koudy.


Jan Karel Pieterse píše:

 

[Jan Karel Pieterse]

Hi Jiri,

We've exactly the same problem on PCs with Windows Vista and W7 both x64. We
don’t use any macros, any add-ins in Excel 2007. I checked Updates and
KB973593 is not installed.
How shall we fix the issue?

And you have all other updates applied?

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

 

[Jiri Koudelka]

Hallo Jan,
yes, all automatic updates are installed to our PCs including SP2 for MSO2.
Jirka


Jan Karel Pieterse píše:

 

[Jan Karel Pieterse]

Hi Jiri,

Odd, the KB you mentioned is the only one I know causing the problem described
here.
Is this on any workbook or just one?

 

[Jiri Koudelka]

The issue is indicated on various excel’s workbooks on two independent PC’s
(one is newly installed 3 weeks ago).

Jan Karel Pieterse píše:

 

[Jan Karel Pieterse]

Hi Jiri,

The issue is indicated on various excel’s workbooks on two independent PC’s
(one is newly installed 3 weeks ago).

Odd indeed. I'm afraid I have no solution at hand right now.

Did this start happening at a certain date?

Have a look at your list of updates (control panel, add/remove programs). What
happens if you remove the last one(s)? (they will be offered by Windows update
again automatically after that)

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

 

[Jiri Koudelka]

Hallo Jan,
the problem started on my PC about 3 months ago but I don’t know the date
exactly. I’ll try to remove some last updates (MSO and/or Windows???). But I
don’t like solutions like that. My PC is fine tuned in the other fields and I
don’t want to do any harm. Maybe I’ll wait for new proper update.
For now I thank you very much for your advice.
Jiri


Jan Karel Pieterse píše:

 

[Jan Karel Pieterse]

Hi Jiri,

the problem started on my PC about 3 months ago but I don’t know the date
exactly. I’ll try to remove some last updates (MSO and/or Windows???). But I
don’t like solutions like that. My PC is fine tuned in the other fields and I
don’t want to do any harm. Maybe I’ll wait for new proper update.
For now I thank you very much for your advice.

Have you tried the hotfix:

http://www.dailydoseofexcel.com/archives/2010/01/14/problems-related-to-kb97347
5
-and-kb973593/

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

 

[Jiri Koudelka]

Hi Jan,
I tried hotfix kb978522 and kb978399 and nothing is solved. No hotfix you
wrote about earlier is installed on my PC.
Maybe a resolution of the graphics is the reason. It is 1920 x 1200 on both
PCs (HP EliteBook 8730w) and problem is presented only if Excel is maximized

 

[Jan Karel Pieterse]

Hi Jiri,

t is 1920 x 1200 on both
PCs (HP EliteBook 8730w) and problem is presented only if Excel is maximized
on primary monitor.

Have you tried things like different screen driver settings, changing printer
driver?

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

 

[Jiri Koudelka]

Bad switching between tabs occurs only if display Y resolution is 1200.
Otherwise it works OK.
Jiri

Jan Karel Pieterse píše:

 

[Jan Karel Pieterse]

Hi Jiri,

Bad switching between tabs occurs only if display Y resolution is 1200.
Otherwise it works OK.

Which makes it likely that this is a problem caused by the display driver
rather than by Excel.

I'm sorry I can't do more to help you!

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

 

[Jiri Koudelka]

Hi Jan
OK. So thank you very much. We are waiting for MSO2010.
Jiri Koudelka

Jan Karel Pieterse píše: