If you want to change the connection from one Excel workbook/worksheet to another Excel workbook/worksheet, you can simply right-click on the data source -> "Edit Connection" and change the path. If the field names are identical, everything will map over. Is this possible in your case?
Thanks for your response. i am editing the connection to different files, and those files have similar column headers. However, because some of my calculated fields incorporate groups or aliases, those groups and aliases are not carrying over; so I am wondering if there is a way to make this occur. In addition, some of the formatting of charts are changing, and some of the calculated fields are actually changing (I think this is a reverberation effect of groupings not being the same).
Thanks for your thoughts on this!