Data - Existing Connections

tomlinsn

Board Regular
Joined
Jan 25, 2011
Messages
71
I have upgraded from Excel 2007 to 2013 and we had a number of defined queries saved in the directory: C:\Users\Smith\AppData\Roaming\Microsoft\Queries, but I need to know how to set this as the default path for Existing Connections in Excel2013. When I press the Existing Connections button, I see none of the queries, but I can navigate slowly by pressing the Browse for More... button.

I want the list of queries to appear in this window like it did I 2007 and there must be a way to tell Excel the path to where these file reside, or where I need to copy them to for them to function in 2013.

Thank you in advance for your assistance.
Tom
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

tomlinsn

Board Regular
Joined
Jan 25, 2011
Messages
71
I discovered that Excel 2013 is looking for the path to My Data Sources. How do I change the path to where this directory is stored (previously local now looking at a network location)?

Thank you,
Tom
 

Watch MrExcel Video

Forum statistics

Threads
1,109,538
Messages
5,529,430
Members
409,876
Latest member
Akash Yadav
Top