So I go into My Documents and double click an existing Excel file to open.
Seems quite normal, no? This document opens, as well as a separate file
"Book1". It gets rather annoying, that I've already opened the file I want.
I didn't open Excel (start w/ a blank workbook) then go File>Open. Even
more annoying is that I didn't make any changes to Book1 (at least that I
can see), but it asks when I try to close Excel "Do you want to save?"
I did have Solver installed and enabled. I've since tried disabling, but
that doesn't seem to do anything. Is this normal behavior? If not, how can
I stop it?
TIA
KenB
This is not an answer...just an additional note.
I have seen this behavior in Excel 2003 as well.
Dave French
> So I go into My Documents and double click an existing Excel file to open.
> Seems quite normal, no? This document opens, as well as a separate file
[quoted text clipped - 11 lines]
>
> KenB
What do you have in your XLStart folder?
> So I go into My Documents and double click an existing Excel file to open.
> Seems quite normal, no? This document opens, as well as a separate file
[quoted text clipped - 10 lines]
>
> KenB

Signature
Dave Peterson
KenB - 13 Mar 2008 16:47 GMT
Solver Table 2007.xlsm
I'll hazard a guess that removing it will stop the 2nd file from opening?
> What do you have in your XLStart folder?
>
[quoted text clipped - 15 lines]
>>
>> KenB
Dave Peterson - 13 Mar 2008 17:25 GMT
What happens when you moved it?
And be sure to look in all your XLStart folders. Depending on your excel
upgrade paths, you may have more than one.
> Solver Table 2007.xlsm
>
[quoted text clipped - 22 lines]
> >
> > Dave Peterson

Signature
Dave Peterson
Ken, I'm wondering if this is the same as my issue. I have a sharted excel
workbook for 2007, and instead of opening the workbook on the first listed
worksheet, it seems to have picked a specific worksheet for the default for
opening. I tried it on a different computer and it didn't do that and opened
normally. Is this similar to your issue?
> So I go into My Documents and double click an existing Excel file to open.
> Seems quite normal, no? This document opens, as well as a separate file
[quoted text clipped - 10 lines]
>
> KenB
Dave Peterson - 12 Mar 2008 22:00 GMT
I'm not Ken, but unless you do something special, excel will remember where you
were when you last saved the workbook. When you reopen the workbook, it'll take
you back to that location.
One of the special things you can do is have a macro that runs when you open
that workbook. It can select any location/worksheet or range that it wants.
Any chance you have a macro running that does this?
> Ken, I'm wondering if this is the same as my issue. I have a sharted excel
> workbook for 2007, and instead of opening the workbook on the first listed
[quoted text clipped - 16 lines]
> >
> > KenB

Signature
Dave Peterson
KenB - 13 Mar 2008 16:49 GMT
Nope... If I open Excel (Start>Programs>Office>Excel), it gives me the
single "Book1" blank workbook. If I simply double click an XLS/XLSX file in
My Documents (or anywhere else), it opens that file, plus a Book1.
> Ken, I'm wondering if this is the same as my issue. I have a sharted
> excel
[quoted text clipped - 22 lines]
>>
>> KenB
Dave French - 13 Mar 2008 17:20 GMT
I have seen this behavior before.
So Ken, is it possible to remove the Book1 from that folder??
Dave French
> Nope... If I open Excel (Start>Programs>Office>Excel), it gives me the
> single "Book1" blank workbook. If I simply double click an XLS/XLSX file
[quoted text clipped - 29 lines]
>>>
>>> KenB