Excel 2007 acting weird

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

Dave
Wed Mar 12 10:42:24 CDT 2008

This is not an answer...just an additional note.
I have seen this behavior in Excel 2003 as well.

Dave French



"KenB" <kbrussel@curtisswright.com> wrote in message
news:%23uKDdVFhIHA.2268@TK2MSFTNGP02.phx.gbl...
> 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
>

Dave
Wed Mar 12 10:49:24 CDT 2008

What do you have in your XLStart folder?

KenB wrote:
>
> 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

--

Dave Peterson

naptownk
Wed Mar 12 15:49:01 CDT 2008

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?


"KenB" wrote:

> 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
>
>
>

Dave
Wed Mar 12 16:00:17 CDT 2008

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?

naptownk wrote:
>
> 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?
>
> "KenB" wrote:
>
> > 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
> >
> >
> >

--

Dave Peterson

KenB
Thu Mar 13 10:47:24 CDT 2008

Solver Table 2007.xlsm

I'll hazard a guess that removing it will stop the 2nd file from opening?
"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:47D7FB84.F478604F@verizonXSPAM.net...
> What do you have in your XLStart folder?
>
> KenB wrote:
>>
>> 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
>
> --
>
> Dave Peterson

KenB
Thu Mar 13 10:49:03 CDT 2008

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.


"naptownk" <naptownk@discussions.microsoft.com> wrote in message
news:A88DF1A0-CD31-46D3-B75D-BD24C25EDF40@microsoft.com...
> 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?
>
>
> "KenB" wrote:
>
>> 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
>>
>>
>>

Dave
Thu Mar 13 11:20:19 CDT 2008

I have seen this behavior before.
So Ken, is it possible to remove the Book1 from that folder??

Dave French


"KenB" <kbrussel@curtisswright.com> wrote in message
news:edzvFHShIHA.5088@TK2MSFTNGP02.phx.gbl...
> 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.
>
>
> "naptownk" <naptownk@discussions.microsoft.com> wrote in message
> news:A88DF1A0-CD31-46D3-B75D-BD24C25EDF40@microsoft.com...
>> 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?
>>
>>
>> "KenB" wrote:
>>
>>> 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
>>>
>>>
>>>
>
>

Dave
Thu Mar 13 11:25:31 CDT 2008

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.

KenB wrote:
>
> Solver Table 2007.xlsm
>
> I'll hazard a guess that removing it will stop the 2nd file from opening?
> "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
> news:47D7FB84.F478604F@verizonXSPAM.net...
> > What do you have in your XLStart folder?
> >
> > KenB wrote:
> >>
> >> 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
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson