How do I change the default location when Importing data?
 

I need to import data fromthe same folder:

c:\Arlington 2006\Bris

Excel always defaults to "Look in" My Data Sources and I have to navigate to
the above path. How can I change the default path for "Look in:"?

How do I change the default location when Importing data?
 

In the menu bar, go to "Tool-Options. In the general tab, there is a
default file location. Put c:\Arlington 2006\Bris in the field.

"Hyerczyk" wrote:

I need to import data fromthe same folder:

c:\Arlington 2006\Bris

Excel always defaults to "Look in" My Data Sources and I have to navigate to
the above path. How can I change the default path for "Look in:"?

How do I change the default location when Importing data?
 

I tried this yet Excel still defaults to looking in "My Data Sources".

"linglc" wrote:

In the menu bar, go to "Tool-Options. In the general tab, there is a
default file location. Put c:\Arlington 2006\Bris in the field.

"Hyerczyk" wrote:

I need to import data fromthe same folder:

c:\Arlington 2006\Bris

Excel always defaults to "Look in" My Data Sources and I have to navigate to
the above path. How can I change the default path for "Look in:"?

How do I change the default location when Importing data?
 

I'll relay the results of an experiment I tried the last time this question came
up(April 20,2005)


Created a folder named hoohah in My Documents.

I went into the registry and changed the folder name from My Data Sources to
hoohah.

Excel found hoohah in My Documents when I asked to Import Data.

I then moved hoohah out of My Documents to GordStuff folder.

When I went to DataImport etc. Excel re-built hoohah in My Documents but any
queries I created were not there, they stayed with the moved folder.

Tried several times with differing names, but Excel or Windows re-builds the
folder in My Documents no matter what it is named.

And sticks the default MS Queries like the Stock Quotes and Money Central into
that folder.

With TweakUI you can change the location of Special Folders like My Documents
if you wish, but when I do, My Data Sources goes with it so not much point.

In short..................forget about it.

Add the folder c:\Arlington 2006\Bris to the My Places bar.

When My Data Sources opens, click on the folder name on My Places bar.


Gord Dibben Excel MVP




On Fri, 7 Jul 2006 03:59:02 -0700, Hyerczyk
wrote:

I tried this yet Excel still defaults to looking in "My Data Sources".

"linglc" wrote:

In the menu bar, go to "Tool-Options. In the general tab, there is a
default file location. Put c:\Arlington 2006\Bris in the field.

"Hyerczyk" wrote:

I need to import data fromthe same folder:

c:\Arlington 2006\Bris

Excel always defaults to "Look in" My Data Sources and I have to navigate to
the above path. How can I change the default path for "Look in:"?

Gord Dibben MS Excel MVP