1 of 1 people found this helpful
Try the following:
- Set up one work book as desired (calculated fields, formatting, etc), using one data source.
- Duplicate that workbook (Save As, or copy-paste the file).
- In the duplicate workbook connect to your next data source, while remaining connected to the original.
- In the Menu bar click Data -> Replace Data Source, and make relevant selections.
This will simply replace one data source with another, leaving everything else as is.
Note that you cannot do this as sheets in one workbook, but each sheet having its own data source, as this procedure above replaces data source for all sheets in the workbook.