Strangely, you can't (Well there may be a setting in the registry, but not
wise)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Bubey" wrote in message
...
One more question please......How can I change the
opening destination?
When I clicked on File/Open, it opened into the My
Doc's on the C drive
rather than the My Doc's on the E drive.

"Nick Hodge"
wrote in
message
...
Bubey

Change the path in
ToolsOptions...GeneralDefault file location

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Bubey" wrote in
message
...
I would like to be able to change the destination
when I do a Save As.
I have an external hard drive that I keep all my
documents on so when
I do a save as it automatically goes to the
Windows My Documents folder.
I would like it to go to the external hard drive
My Documents folder.
Thanks in advance for the help.