Failure to or Slow moving between Worksheet Files.

  • Thread starter Thread starter Phil
  • Start date Start date
P

Phil

Hi,

I sure could use a little bit of advice to solve a
problem which has just popped-up in the last month or so.

I have three XLS files which are all opened at the same
time by a container XLS file. One of the files opens up
as the active worksheet. The other two files are
displayed at the bottom of the screen in the system tray.

When attempting to switch between the different files by
clicking on the desired XLS file in the system tray,
either nothing happens or (with luck) the switch is
made. It would appear that focus is given to the desired
system tray button for a 1 second interval of time and
then returned to the active XLS button control.

Usually, the switch is made correctly on the second try
but there always has to be a second try.

Is this a problem within Excel itself or is this a WinXP
HE problem.

FYI I'm running WinXP with all updates and Service
Releases/Packs installed. MS Office is the 2002 edition
and the Office Update Center tells me that I have
installed all available updates.

Any help would be greatly appreciated. Thanks in advance.

Phil
 
Does this behaviour happen with any other apps? If so this looks like a
system problem.

Does it happen with other workbooks or just these specifically? If so it's
likely to be an Excel installation issue.

Assuming neither is the case first thing I would check is what's running in
the workbooks. A prime candidate would be VBA code running timers or
worksheet_change events. Custom UDF's (user defined functions) which take a
long time to execute could also be to blame.

Open the VBA editor for each workbook and have a look around for the
aforementioned.


--
Regards,


Bill Lunney
www.billlunney.com
 
Back
Top