Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
How to change "automax" to "autosum"? (probablyl wrong terminology) | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
"Invalid Web Query" error on opening a 2003 worksheet | Excel Discussion (Misc queries) |