Re: SAVE AS default directory

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



In article <1189111033.614205.212380@xxxxxxxxxxxxxxxxxxxxxxxxxxx>,
ronald_chinn@xxxxxxxxx wrote:

I'm running the 2004 version of Excel on a brand new PowerBook (Mac OS
X 10.4.10). I'm frustrated because the SAVE AS function appears to
default to a silly location - logically, when you hit SAVE AS, you
would expect that it would default to saving the new file into the
location from whence the original file came. I can't find a
preference setting which allows me to do this - am I just blind? Any
help would be greatly appreciated so I can stop losing files and
having them strewn about my drive.

P.S.: I note that Word does not have this program - it defaults to
placing files into the same directory as the original location. And
as far as I can remember, the Windows version of Excel does this too.
It just seems to be the Mac version.

I think your "logically, when you hit SAVE AS, you would expect that it
would default to saving the new file into the location from whence the
original file came" is common, but by no means universal logic. I get
just as frustrated with Word's method...

Most of the time, I save emailed or downloaded client files into a
sandbox folder, then, after I've edited/modified them, I Save As them to
my client hierarchy. There's no *way* I want XL files saving back to the
sandbox...

My solution: I save all my client files with the client number prefix in
the filename. I set, in my business startup addin, XL's Default file
location (Preferences/General) to my Client folder, so that it ALWAYS
defaults to that folder on Save As.

Then I use attached Mac OS X Folder actions to automatically distribute
any files saved to the Client folder into the appropriate subfolders.
.



Relevant Pages

  • Re: SAVE AS default directory
    ... would default to saving the new file into the location from whence the ... original file came" is common, but by no means universal logic. ... my client hierarchy. ... location to my Client folder, ...
    (microsoft.public.mac.office.excel)
  • Re: EMERGENCY! Offline Files Disappearing / Vanishing
    ... My Documents made "Available Offline" ... Client laptop: ... files were all there under his appropriate user folder on the server. ...
    (microsoft.public.windows.server.sbs)
  • Re: EMERGENCY! Offline Files Disappearing / Vanishing
    ... My Documents made "Available Offline" ... Client laptop: ... were all there under his appropriate user folder on the server. ...
    (microsoft.public.windows.server.sbs)
  • RE: Fax monitor incoming + outgoing calls?
    ... The detail steps to install share fax client as follows: ... Start server management console, locate Client Computers node, click ... To the folder redirection GPO issue: ... How to stop Folder Redirection in Windows Server 2003 and in Windows 2000 ...
    (microsoft.public.windows.server.sbs)
  • Re: Office Docs wont Open? and BU Drive not Recognized?
    ... This Client had a simple Peer-to-Peer network with 5 WinXP Pro computers. ... The secretary had a folder on her C:\ drive called RDF1, ... Server, and had all of the clients connected to the Domain, I just did a Cut ... If I copy the document to the local Client, the document opens fine? ...
    (microsoft.public.windows.server.sbs)