Location of Excel Database Queries

[TresGay]

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]

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