After opening excel, try to do a "save as" and it always want to go back and
save in XLSTART directory, rather than where all the excel work is saved.
Please tell me what I have to tell Excel to only pull from XLSTART at the
beginning but save as where it says in the options section.

Maybe I'm not following but when you do a Save As Excel always defaults to
the path the workbook was opened from. The Default File Location sets the
current path when Excel starts but the current path follows each Open or
Save As.

--
Jim
"John McCabe" <jlmccabes@cfl.rr.com> wrote in message
news:4874a49b$0$12018$9a6e19ea@unlimited.newshosti ng.com...
| After opening excel, try to do a "save as" and it always want to go back
and
| save in XLSTART directory, rather than where all the excel work is
saved.
| Please tell me what I have to tell Excel to only pull from XLSTART at the
| beginning but save as where it says in the options section.
|
|

Default = c:\wks where all the excel worksheets are kept. Excel opens
with pulling from the XLSTART directory that is buried in the C:\ drive.
Opens with Book1. Then trying to save a file it defaults to save in the
xlstart place. Tools>Options>Default is set to C:\wks so it should save
files there - not the start up location.
"Jim Rech" <jrrech@hotmail.com> wrote in message
news:uPjS%23Ec4IHA.2332@TK2MSFTNGP03.phx.gbl...
> Maybe I'm not following but when you do a Save As Excel always defaults to
> the path the workbook was opened from. The Default File Location sets the
> current path when Excel starts but the current path follows each Open or
> Save As.
>
> --
> Jim
> "John McCabe" <jlmccabes@cfl.rr.com> wrote in message
> news:4874a49b$0$12018$9a6e19ea@unlimited.newshosti ng.com...
> | After opening excel, try to do a "save as" and it always want to go back
> and
> | save in XLSTART directory, rather than where all the excel work is
> saved.
> | Please tell me what I have to tell Excel to only pull from XLSTART at
> the
> | beginning but save as where it says in the options section.
> |
> |
>
>

What version of excel are you using?

If you start excel and type this into A1 of book1 (that brand new workbook):
=cell("Filename",a1)
What do you get back?


John McCabe wrote:
>
> Default = c:\wks where all the excel worksheets are kept. Excel opens
> with pulling from the XLSTART directory that is buried in the C:\ drive.
> Opens with Book1. Then trying to save a file it defaults to save in the
> xlstart place. Tools>Options>Default is set to C:\wks so it should save
> files there - not the start up location.
> "Jim Rech" <jrrech@hotmail.com> wrote in message
> news:uPjS%23Ec4IHA.2332@TK2MSFTNGP03.phx.gbl...
> > Maybe I'm not following but when you do a Save As Excel always defaults to
> > the path the workbook was opened from. The Default File Location sets the
> > current path when Excel starts but the current path follows each Open or
> > Save As.
> >
> > --
> > Jim
> > "John McCabe" <jlmccabes@cfl.rr.com> wrote in message
> > news:4874a49b$0$12018$9a6e19ea@unlimited.newshosti ng.com...
> > | After opening excel, try to do a "save as" and it always want to go back
> > and
> > | save in XLSTART directory, rather than where all the excel work is
> > saved.
> > | Please tell me what I have to tell Excel to only pull from XLSTART at
> > the
> > | beginning but save as where it says in the options section.
> > |
> > |
> >
> >

--

Dave Peterson

Mainly 2003 (2007 if I have time and it is easy) but problem comes up in
both versions. I got this C:\Program Files\Microsoft
Office\OFFICE11\xlstart\[Book1.xls]Sheet3

Says Office 12 in the 2007 version.

"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:4874DC82.412302D8@verizonXSPAM.net...
> What version of excel are you using?
>
> If you start excel and type this into A1 of book1 (that brand new
> workbook):
> =cell("Filename",a1)
> What do you get back?
>
>
> John McCabe wrote:
>>
>> Default = c:\wks where all the excel worksheets are kept. Excel opens
>> with pulling from the XLSTART directory that is buried in the C:\ drive.
>> Opens with Book1. Then trying to save a file it defaults to save in the
>> xlstart place. Tools>Options>Default is set to C:\wks so it should
>> save
>> files there - not the start up location.
>> "Jim Rech" <jrrech@hotmail.com> wrote in message
>> news:uPjS%23Ec4IHA.2332@TK2MSFTNGP03.phx.gbl...
>> > Maybe I'm not following but when you do a Save As Excel always defaults
>> > to
>> > the path the workbook was opened from. The Default File Location sets
>> > the
>> > current path when Excel starts but the current path follows each Open
>> > or
>> > Save As.
>> >
>> > --
>> > Jim
>> > "John McCabe" <jlmccabes@cfl.rr.com> wrote in message
>> > news:4874a49b$0$12018$9a6e19ea@unlimited.newshosti ng.com...
>> > | After opening excel, try to do a "save as" and it always want to go
>> > back
>> > and
>> > | save in XLSTART directory, rather than where all the excel work is
>> > saved.
>> > | Please tell me what I have to tell Excel to only pull from XLSTART at
>> > the
>> > | beginning but save as where it says in the options section.
>> > |
>> > |
>> >
>> >
>
> --
>
> Dave Peterson

That means that you're actually opening a real workbook named book1.xls in that
folder.

You want to be creating a new workbook based on book.xlt (xl2003's name)
instead.

So go to that C:\Program Files\Microsoft Office\OFFICE11\xlstart

folder and move or delete book1.xls


John McCabe wrote:
>
> Mainly 2003 (2007 if I have time and it is easy) but problem comes up in
> both versions. I got this C:\Program Files\Microsoft
> Office\OFFICE11\xlstart\[Book1.xls]Sheet3
>
> Says Office 12 in the 2007 version.
>
> "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
> news:4874DC82.412302D8@verizonXSPAM.net...
> > What version of excel are you using?
> >
> > If you start excel and type this into A1 of book1 (that brand new
> > workbook):
> > =cell("Filename",a1)
> > What do you get back?
> >
> >
> > John McCabe wrote:
> >>
> >> Default = c:\wks where all the excel worksheets are kept. Excel opens
> >> with pulling from the XLSTART directory that is buried in the C:\ drive.
> >> Opens with Book1. Then trying to save a file it defaults to save in the
> >> xlstart place. Tools>Options>Default is set to C:\wks so it should
> >> save
> >> files there - not the start up location.
> >> "Jim Rech" <jrrech@hotmail.com> wrote in message
> >> news:uPjS%23Ec4IHA.2332@TK2MSFTNGP03.phx.gbl...
> >> > Maybe I'm not following but when you do a Save As Excel always defaults
> >> > to
> >> > the path the workbook was opened from. The Default File Location sets
> >> > the
> >> > current path when Excel starts but the current path follows each Open
> >> > or
> >> > Save As.
> >> >
> >> > --
> >> > Jim
> >> > "John McCabe" <jlmccabes@cfl.rr.com> wrote in message
> >> > news:4874a49b$0$12018$9a6e19ea@unlimited.newshosti ng.com...
> >> > | After opening excel, try to do a "save as" and it always want to go
> >> > back
> >> > and
> >> > | save in XLSTART directory, rather than where all the excel work is
> >> > saved.
> >> > | Please tell me what I have to tell Excel to only pull from XLSTART at
> >> > the
> >> > | beginning but save as where it says in the options section.
> >> > |
> >> > |
> >> >
> >> >
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson

Thank You so much. I deleted from 2003 and 2007 the XLSTART files. Now it
only goes to where it should be saving to. If you only knew how much
problem it was when save to took you down deep in the system and you had to
work your way backto right place. Thank You again!!
"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:4875F139.E8881BD7@verizonXSPAM.net...
> That means that you're actually opening a real workbook named book1.xls in
> that
> folder.
>
> You want to be creating a new workbook based on book.xlt (xl2003's name)
> instead.
>
> So go to that C:\Program Files\Microsoft Office\OFFICE11\xlstart
>
> folder and move or delete book1.xls
>
>
> John McCabe wrote:
>>
>> Mainly 2003 (2007 if I have time and it is easy) but problem comes up in
>> both versions. I got this C:\Program Files\Microsoft
>> Office\OFFICE11\xlstart\[Book1.xls]Sheet3
>>
>> Says Office 12 in the 2007 version.
>>
>> "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
>> news:4874DC82.412302D8@verizonXSPAM.net...
>> > What version of excel are you using?
>> >
>> > If you start excel and type this into A1 of book1 (that brand new
>> > workbook):
>> > =cell("Filename",a1)
>> > What do you get back?
>> >
>> >
>> > John McCabe wrote:
>> >>
>> >> Default = c:\wks where all the excel worksheets are kept. Excel
>> >> opens
>> >> with pulling from the XLSTART directory that is buried in the C:\
>> >> drive.
>> >> Opens with Book1. Then trying to save a file it defaults to save in
>> >> the
>> >> xlstart place. Tools>Options>Default is set to C:\wks so it should
>> >> save
>> >> files there - not the start up location.
>> >> "Jim Rech" <jrrech@hotmail.com> wrote in message
>> >> news:uPjS%23Ec4IHA.2332@TK2MSFTNGP03.phx.gbl...
>> >> > Maybe I'm not following but when you do a Save As Excel always
>> >> > defaults
>> >> > to
>> >> > the path the workbook was opened from. The Default File Location
>> >> > sets
>> >> > the
>> >> > current path when Excel starts but the current path follows each
>> >> > Open
>> >> > or
>> >> > Save As.
>> >> >
>> >> > --
>> >> > Jim
>> >> > "John McCabe" <jlmccabes@cfl.rr.com> wrote in message
>> >> > news:4874a49b$0$12018$9a6e19ea@unlimited.newshosti ng.com...
>> >> > | After opening excel, try to do a "save as" and it always want to
>> >> > go
>> >> > back
>> >> > and
>> >> > | save in XLSTART directory, rather than where all the excel work
>> >> > is
>> >> > saved.
>> >> > | Please tell me what I have to tell Excel to only pull from XLSTART
>> >> > at
>> >> > the
>> >> > | beginning but save as where it says in the options section.
>> >> > |
>> >> > |
>> >> >
>> >> >
>> >
>> > --
>> >
>> > Dave Peterson
>
> --
>
> Dave Peterson

Do you recall what you saw in the title bar when you opened excel?

Did you see
book1.xls
or
book1
(without the extension)

If you saw the .xls, then that should have served as a hint that you were
working on a file that was already saved at least once.

But windows has an option to hide the extensions for known files. Then you
wouldn't have seen that helpful hint.

I'd check to see what that setting is and make sure windows always shows the
extensions (in Windows Explorer, too!).

In Windows XP, but I bet all versions of Windows are similar.
Start windows explorer (not MSIE)
Tools|Folder options|View tab
scroll down and make sure that "Hide extensions for know file types" is not
checked.

This could actually make your pc a little safer, too.

With this option checked, you could get an attachment that looks like:
NicePicture.jpg
when in reality, its real name is:
NicePicture.jpg.exe
or
NicePicture.jpg.vbs

If you see the real extension, you may be able to avoid clicking on something
that is painful.

======
ps.

You could also check for the file name by:
Open excel
File|Properties|General tab (xl2003 menus)
and see if there's a location (so that you know it's been saved at least once).


John McCabe wrote:
>
> Thank You so much. I deleted from 2003 and 2007 the XLSTART files. Now it
> only goes to where it should be saving to. If you only knew how much
> problem it was when save to took you down deep in the system and you had to
> work your way backto right place. Thank You again!!
> "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
> news:4875F139.E8881BD7@verizonXSPAM.net...
> > That means that you're actually opening a real workbook named book1.xls in
> > that
> > folder.
> >
> > You want to be creating a new workbook based on book.xlt (xl2003's name)
> > instead.
> >
> > So go to that C:\Program Files\Microsoft Office\OFFICE11\xlstart
> >
> > folder and move or delete book1.xls
> >
> >
> > John McCabe wrote:
> >>
> >> Mainly 2003 (2007 if I have time and it is easy) but problem comes up in
> >> both versions. I got this C:\Program Files\Microsoft
> >> Office\OFFICE11\xlstart\[Book1.xls]Sheet3
> >>
> >> Says Office 12 in the 2007 version.
> >>
> >> "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
> >> news:4874DC82.412302D8@verizonXSPAM.net...
> >> > What version of excel are you using?
> >> >
> >> > If you start excel and type this into A1 of book1 (that brand new
> >> > workbook):
> >> > =cell("Filename",a1)
> >> > What do you get back?
> >> >
> >> >
> >> > John McCabe wrote:
> >> >>
> >> >> Default = c:\wks where all the excel worksheets are kept. Excel
> >> >> opens
> >> >> with pulling from the XLSTART directory that is buried in the C:\
> >> >> drive.
> >> >> Opens with Book1. Then trying to save a file it defaults to save in
> >> >> the
> >> >> xlstart place. Tools>Options>Default is set to C:\wks so it should
> >> >> save
> >> >> files there - not the start up location.
> >> >> "Jim Rech" <jrrech@hotmail.com> wrote in message
> >> >> news:uPjS%23Ec4IHA.2332@TK2MSFTNGP03.phx.gbl...
> >> >> > Maybe I'm not following but when you do a Save As Excel always
> >> >> > defaults
> >> >> > to
> >> >> > the path the workbook was opened from. The Default File Location
> >> >> > sets
> >> >> > the
> >> >> > current path when Excel starts but the current path follows each
> >> >> > Open
> >> >> > or
> >> >> > Save As.
> >> >> >
> >> >> > --
> >> >> > Jim
> >> >> > "John McCabe" <jlmccabes@cfl.rr.com> wrote in message
> >> >> > news:4874a49b$0$12018$9a6e19ea@unlimited.newshosti ng.com...
> >> >> > | After opening excel, try to do a "save as" and it always want to
> >> >> > go
> >> >> > back
> >> >> > and
> >> >> > | save in XLSTART directory, rather than where all the excel work
> >> >> > is
> >> >> > saved.
> >> >> > | Please tell me what I have to tell Excel to only pull from XLSTART
> >> >> > at
> >> >> > the
> >> >> > | beginning but save as where it says in the options section.
> >> >> > |
> >> >> > |
> >> >> >
> >> >> >
> >> >
> >> > --
> >> >
> >> > Dave Peterson
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson