Opening to the "wrong" worksheet
 

Hi. I sent out a time keeper workbook to 200+ users. Each user saved their
individual workbook -- each worksheet reflects a different week ending.

Some users are complaining because each time they open their workboook,
rather than defaulting to where they were the last time they saved it (for
example 'today') it is defaulting to another worksheet (last week's for most
people).

The oddest part is... it is not universal for all users. AND -- the
workbook with th eproblem appears to have a problem on the particular machine
-- if you open it somewhere else (i.e,. access the shared drive from a
different computer) than the problem goes away. So it seems like it's some
sort of configuration in Excel.

Ideas?

Opening to the "wrong" worksheet
 

There is no "configuration" setting in Excel that changes the default behaviour
of Excel opening to the worksheet that was active when the workbook was saved
and closed.

UNLESS there is some workbook_open or auto_open or beforeclose code that
activates a particular sheet.

Some users may be disabling macros which would negate any code that activates a
certain sheet.


Gord Dibben MS Excel MVP

On Wed, 19 Dec 2007 06:06:00 -0800, beata
wrote:

Hi. I sent out a time keeper workbook to 200+ users. Each user saved their
individual workbook -- each worksheet reflects a different week ending.

Some users are complaining because each time they open their workboook,
rather than defaulting to where they were the last time they saved it (for
example 'today') it is defaulting to another worksheet (last week's for most
people).

The oddest part is... it is not universal for all users. AND -- the
workbook with th eproblem appears to have a problem on the particular machine
-- if you open it somewhere else (i.e,. access the shared drive from a
different computer) than the problem goes away. So it seems like it's some
sort of configuration in Excel.

Ideas?

Opening to the "wrong" worksheet
 

Thanks a lot. Not really what I wanted to read but I appreciate the time you
toko to answer.

beata

"Gord Dibben" wrote:

There is no "configuration" setting in Excel that changes the default behaviour
of Excel opening to the worksheet that was active when the workbook was saved
and closed.

UNLESS there is some workbook_open or auto_open or beforeclose code that
activates a particular sheet.

Some users may be disabling macros which would negate any code that activates a
certain sheet.


Gord Dibben MS Excel MVP

On Wed, 19 Dec 2007 06:06:00 -0800, beata
wrote:

Hi. I sent out a time keeper workbook to 200+ users. Each user saved their
individual workbook -- each worksheet reflects a different week ending.

Some users are complaining because each time they open their workboook,
rather than defaulting to where they were the last time they saved it (for
example 'today') it is defaulting to another worksheet (last week's for most
people).

The oddest part is... it is not universal for all users. AND -- the
workbook with th eproblem appears to have a problem on the particular machine
-- if you open it somewhere else (i.e,. access the shared drive from a
different computer) than the problem goes away. So it seems like it's some
sort of configuration in Excel.

Ideas?