Excel 2016 file loations

Copper Contributor

Just changed to new computer where I copied "my documents" to new computer "my documents.  Don't have a problem finding the files but querys are not working as they are looking for a different "computer name".  How can I change that.  Querys created before were "users/computername\my documents\file name"  I need it to look in "users\computername1\my documents\file name\".  Not having problem with the workbooks themselves but only querys.

0 Replies