KNOWLEDGE BASE

Replacing the Data Source for a Single Sheet in a Workbook


Published: 15 Sep 2014
Last Modified Date: 30 Mar 2017

Question

How to replace the data source for a single sheet in a workbook. When replacing a data source in a duplicated worksheet, the data source is replaced in the duplicated worksheet as well as the original worksheet.

Environment

  • Tableau Desktop 
  • Windows
  • Mac

Answer

Use the following workaround:
  1. Follow the steps in Copy and Paste Sheets to copy the sheet into a new blank workbook.
  2. Verify that the new workbook contains open data connections to the original data source of the copied worksheet, as well as the new data source.
  3. In the new workbook, replace the original data source for the copied worksheet with the new desired data source. For more information, see Replacing Data Sources.
  4. Copy the worksheet back into the original workbook. The original workbook should also have the new desired data source connection to ensure a smooth copy. 

Additional Information

  • The ability to replace or edit a data connection for only a single sheet within a workbook is not currently available.
  • To voice your support for the inclusion of this feature in a future product release, add your vote to the following Community Idea: Change datasource on one worksheet and not others.
Did this article resolve the issue?