Location of Excel Database Queries

TresGay · Apr 23rd, 2002, 11:08 AM

Hello ~

Is there a way to change the location of where Excel goes to look for database queries? It defaults to C:ProgramsMicrosoftOfficeQueries. I'd really like to have it go and look in one place on a server so that I wouldn't have to go around and put this query on everyone's desk top.

SERENITY NOW ahhh I feel better....

Have a great day, thanks for any help you can give me ... if you can't give me any help, thanks for trying.

Tres

lenze · Apr 23rd, 2002, 11:25 AM

Start Miscrosoft Query adn when the dialogue box is displayed, choose options. You will see a message that directs where Excel looks for queries with the option to add a new folder location

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 23rd, 2002, 11:08 AM	#1
TresGay New Member Join Date: Apr 2002 Location: Capital One Posts: 6	Hello ~ Is there a way to change the location of where Excel goes to look for database queries? It defaults to C:ProgramsMicrosoftOfficeQueries. I'd really like to have it go and look in one place on a server so that I wouldn't have to go around and put this query on everyone's desk top. SERENITY NOW ahhh I feel better.... Have a great day, thanks for any help you can give me ... if you can't give me any help, thanks for trying. Tres

Apr 23rd, 2002, 11:25 AM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	Start Miscrosoft Query adn when the dialogue box is displayed, choose options. You will see a message that directs where Excel looks for queries with the option to add a new folder location