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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
> >> news:(E-Mail Removed)...
> >> > 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" <(E-Mail Removed)> wrote in message
> >> >> news:uPjS%(E-Mail Removed)...
> >> >> > 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" <(E-Mail Removed)> wrote in message
> >> >> > news:4874a49b$0$12018$(E-Mail Removed)...
> >> >> > | 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
|
Similar Threads
