Changing directory when opening files in excel 2004

[christiaan.janssen]

My default settings for file locations are set in Preferences.
When I perform File Open, Excel will open the right location.
Within this default location are many sub directories with Excel
files.

When I open a file in a sub directory, work on it and decide to open
another file, Excel will go back to the Preference directory and not
ot the directory which was opened more recently.

When one does something similar in Word, Word will go to the directory
which was opened most recently. In the way I work, this is very
convenient.
Why is there is difference between Excel and Word in this respect. I
prefer the way Word handles File Open, after you have already opened a
file in a specific directory.
These specific directories are always sub directories of the one
mentioned in Preferences.

Another problem is that when you sort the directory listing in Word on
date for instance, Word will remember this, while Excel always goes
back to the standard sorting.

Hope someone can help.
I am using Office 2004 and OS X 10.3.6

 

[JE McGimpsey]

(e-mail address removed) ([email protected])
wrote:

My default settings for file locations are set in Preferences.
When I perform File Open, Excel will open the right location.
Within this default location are many sub directories with Excel
files.

When I open a file in a sub directory, work on it and decide to open
another file, Excel will go back to the Preference directory and not
ot the directory which was opened more recently.

When one does something similar in Word, Word will go to the directory
which was opened most recently. In the way I work, this is very
convenient.
Why is there is difference between Excel and Word in this respect. I
prefer the way Word handles File Open, after you have already opened a
file in a specific directory.
These specific directories are always sub directories of the one
mentioned in Preferences.

Another problem is that when you sort the directory listing in Word on
date for instance, Word will remember this, while Excel always goes
back to the standard sorting.

Hope someone can help.

I don't know why the difference. Personally, my workflow is such that I
prefer the way Excel does it.

However, if you'd like the behavior changed, or a preference that would
allow a choice, please send a message to MacBU via the Help/Send
Feedback on Excel menu item