I'm having a similar issue WHen opening an excel spreadsheet from a location
other than the Default Office location whenever I do a Save As Excel opens My
Documents to save it there rather than the original location. If I open
Excel 1st then open the spreadsheet from excel it saves to the location the
document was opened from. This occurred after upgrading to XP SP2 and Office
SP3. I have machines that have not yet been updated and they don't exhibit
this behavior

"Anne Troy" wrote:

> Good call! Dying to know if you're right...
> *******************
> ~Anne Troy
>
> www.OfficeArticles.com
>
>
> "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
> news:42EABEAA.26E6F51B@verizonXSPAM.net...
> > Since you're seeing the SaveAs dialog, it sounds like excel knows that
> this file
> > can't be overwritten.
> >
> > If you look at the title bar, do you see [Read-Only] there?
> >
> > If you do, then either the user opened the workbook in readonly mode. Or
> the
> > file could have its attributes set to ReadOnly (via windows explorer???).
> Or it
> > could mean that the user doesn't have write access to that drive/folder.
> >
> > If there's another user who has the file open, this user may have ignored
> the
> > message that said it was in use and answered "yes" to the readonly prompt.
> >
> > ==========
> >
> > Arrrrrrgggggggghhhh!
> >
> > My "real" guess (after re-reading your post).
> >
> > I bet that user who is having the trouble double clicks on the file in
> windows
> > explorer to open it.
> >
> > If you walk by that user's pc and ask them to rightclick on that file (in
> > windows explorer), you should see one option in bold letters. For most
> people,
> > Open should be the default action for .xls files.
> >
> > But I'm guessing you see New in bold. That means that windows/excel will
> treat
> > that file (and all .xls files) as a template.
> >
> > One way to fix this is:
> >
> > Close Excel and
> > Windows Start Button|Run
> > excel /unregserver
> > then
> > Windows Start Button|Run
> > excel /regserver
> >
> > The /unregserver & /regserver stuff resets the windows registry to excel's
> > factory defaults.
> >
> >
> > =========
> > Yeah, I could have deleted that first portion of my post. But it was a
> lot of
> > typing and it could have been useful <vbg>.
> >
> >
> >
> >
> > dmtech wrote:
> > >
> > > I just re-checked to make sure of the extension, it is definitly xls.
> The
> > > filename is the current month and day as 5-29 for today when you click
> on the
> > > save icon you get a Save as box with a filename of 5-291 with an
> extension of
> > > xls with the default folder selected instead of the folder where the
> file
> > > came from. Prior to this week, when you click on the save icon it just
> saved
> > > the file over the original. This system is used by several people, on
> > > different shifts, week-end shifts, and fill-ins for vacations and sick
> calls.
> > > The file is an event log and the officer on duty enters data in at least
> once
> > > an hour, everything has worked OK for the past several years and just
> started
> > > to have problems, no one will admit to makeing any changes in the file.
> > > Re-installing the master, which is write protected on the network makes
> no
> > > improvement. The same master installed on other computers works OK.
> > > --
> > > dmtech
> > >
> > > "Anne Troy" wrote:
> > >
> > > > 1,2,3? Sounds like the file was saved as a template. Are you sure the
> file
> > > > name is XLS and not XLT?
> > > > *******************
> > > > ~Anne Troy
> > > >
> > > > www.OfficeArticles.com
> > > >
> > > >
> > > > "dmtech" <dmtech@discussions.microsoft.com> wrote in message
> > > > news:3869892F-B18A-458D-9E49-9D9661C9EC2A@microsoft.com...
> > > > > Using Excel97. when my user opens a file, makes changes and then
> clicks
> > > > the
> > > > > save icon, it used to save the changes to the file that was
> originally
> > > > > opened, now it brings up a save as dialog box, adds a 1,2,3.... to
> the
> > > > > filename and saves it in the default folder instead of where it came
> from.
> > > > > How do I put it back to the way it was
> > > > > --
> > > > > dmtech
> > > >
> > > >
> > > >
> >
> > --
> >
> > Dave Peterson
>
>
>