Getting Excel to open up to a dif folder?

A

Andy D

I know that by default, when you go to FILE / OPEN /
it goes to My Documents.
How do I get Excel to open up to a different folder by default?

Thanks
Andy
 
J

JulieD

Hi Andy

the settings can be changed under tools / options and on the General tab.

Cheers
JulieD

I know that by default, when you go to FILE / OPEN /
it goes to My Documents.
How do I get Excel to open up to a different folder by default?

Thanks
Andy
 
D

David McRitchie

Hi Andy,
same as Julie said,
Tools, Options, General, Default File location
i.e. C:\h\excel2k

but be
careful that you do not use the alternated startup
directory field for this, all file there will be opened
up just like your XLSTART directory.t

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

I know that by default, when you go to FILE / OPEN /
it goes to My Documents.
How do I get Excel to open up to a different folder by default?

Thanks
Andy
 
J

JulieD

thanks for the feedback :)

Thanks to both of you! That worked great!
I knew there was a way, just couldn't remember where to look.

Andy

I know that by default, when you go to FILE / OPEN /
it goes to My Documents.
How do I get Excel to open up to a different folder by default?

Thanks
Andy
 
A

Andy D

Thanks to both of you! That worked great!
I knew there was a way, just couldn't remember where to look.

Andy

I know that by default, when you go to FILE / OPEN /
it goes to My Documents.
How do I get Excel to open up to a different folder by default?

Thanks
Andy
 
Top