In Excel 2007, can I have the File-Open dialog go to last folder?

[jsteph]

Hi all,
It seems other versions of Office products would open the File dialog box to the last folder I looked in for that program.

Excel 2007 seems to alway open to My Documents. I never put excel sheets there, most of our files go on a server.

So isn't there some registry setting to:
A: Set a default directory *other* than My Documents which nobody uses.
B: Set it to remember the last File-Open location

Thanks,
--Jim

 

[Lilliabeth]

Change the default directory:
Microsoft Office button > Excel Options (or Word Options or whatever) > Save category



--Lilliabeth