Hi,

We recently upgraded some PCs from office 2010 to 2013 and in excel when we click on Data tab, Existing Connections all the Connections that were there in excel 2010 are now gone.

The *.oqy files were saved under c$\Users\username\AppData\Roaming\Microsoft\Queries in Excel 2010.

Has anyone comes across this issue?

Thanks

• Edited by Niall Leahy 20 hours 33 minutes ago

Hi Niall,

As far as I know, if you do not see the connection that you want, you can create a connection. Click Browse for More, and then in the Select Data Source dialog box, click New Source to start the Data Connection Wizard so that you can select the data source that you want to connect to.

Please Note: If you choose a connection from the Connection files on the network or Connection files on this computer categories, the connection file is copied into the workbook as a new workbook connection, and is then used as the new connection information.

Hope it's helpful.

Regards,

Emi Zhang
TechNet Community Su