Deafult Data Source Folder

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have some saved Queries. To run them, I go to Data>Import External
Data>Import Data. This opens to a folder called "My Data Sources" which is
under MyDocuments on my C drive. is there a way to configure Excel to open
to a diferent folder by default. I know how to change the default
spreadsheet folder but not this one ????
 
Dave

Doesn't appear so.

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 Data>Import 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.


Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Source Default 2
Anyone Else Facing Public Folder Migration Errors in Exchange? 0
Changing default "import" folder 1
Import external data problem 1
Problem with Import Data path 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How to change Import Data source folder "permanently"? 1
External Data Refresh Issues 0

Back
Top