Changing company in existing query

Hi, I would like to do an excel sheet with an odbc connection to Navision that fetches different information (mainly customer balance amount). Is it possible some way to save the excelbook and then make a copy where I can change which Company in Navision it should fetch the data? The benefit of this is I don’t have to do everything again for every new company in our database, just to change existing query in Excel and then save it as a new excelbook would save a lot of time. I have tried to different ODBC sources but it seems that Excel saves information about which company the original query used and I can’t see how to change this. I know that this is a excel/query question but perhaps some of you have experience of this? We use the native database (Attain 3.60). Best regards Daniel