Unwanted Workbook Opening

W

willyboynj

When I open a particular workbook and make changes, I sometimes notic
that another, unrelated workbook is open.

When I just open the desired workbook and check before doing anything
I find that the unrelated one is not (yet) present.

I'm not using an autoopen macro, and there are no references in th
desired workbook to the unrelated one.

I've not been able to determine what actions (if any) trigger th
unwanted opening, partly because the phenomenon appearst o b
intermittent and I forget about it until it occurs again.

I'm using Excel 2003 (11.6355.6360) SP-1 and the operating system is X
Home.

Any ideas?

Thank you.

Bill Shapir
 
D

Dave Peterson

You say you're not using auto_open, but does your workbook have any other macros
in it--maybe even event procedures?

If that second one isn't there when you open the first, it sounds like it could
be a macro.

Do you have any other workbooks that are open that could be opening that one.

And this should have been my first question, what's the name of that other
workbook?

Maybe you could move it/rename it and see if you get a macro error.

Or you could start excel in safe mode and stop all macros from running:

Close excel
windows start button|run
excel /safe

file|open your workbook
and see if anything unwanted shows up.
 
W

willyboynj

Dave -

Thanks for your reply. Sorry I didn't respond sooner, but I'm new t
these forums and had trouble finding my query. (Is there a way I ca
search directly for my username?)

In answer to your questions:

None of my macros runs automatically, all have either shortcut keys o
taskbar buttons. In any case, I searched all of them and found n
reference to the unwanted workbook or to any other workbook.

The name of the unwanted workbook is "Promotional Pens". I had in fac
renamed it as one of my first attempts to solve the problem. It used t
be called just "Pens".

Thanks for the tip about Excel /safe. I'll use it the next few times
open the workbook that has the problem, and see if it seems to make
difference. (If it does, there will be an even greater mystery since
as noted above, none of the macros refers to any other workbook.)

Bill Shapir
 
L

LB79

I had a similar problem a few months ago. The cause was in the general
tab of options - check if you have an Alternitive startup file
location. If you have, is it the same location of this unrelated
workbook? if this is the case you can remove the path of this
alternitive location.
 
W

willyboynj

LB79 -

Thanks for the suggestion. I checked the General options and I specif
only one folder. Interestingly, it is NOT the folder in which th
unwanted workbook resides.

Your suggestion also prompted me to see if the workbook is in more tha
one place. Unfortunately, it is not.

Bill Shapir
 
D

Dave Peterson

And if it's intermittent, then I wouldn't think that alternate startup location
would be the culprit.
 
Top