Data - Existing Connections

[tomlinsn]

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

 

[tomlinsn]

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