Duplicating the Connection

Sometimes you’ll want to make changes to a data connection such as add more tables, hide and show fields, set field defaults, and so on. When you make these changes it affects all sheets that use the data connection. You can duplicate a connection so that you can make the changes without affecting the existing sheets. To duplicate a connection select a data source on the Data menu and then select Duplicate. When you duplicate a connection the name has “(copy)” appended to the end.