Last Modified Date: 18 Jan 2024
Environment
- Tableau Desktop
- Windows
- Mac
Answer
Option 1
Upgarde to Tableau Desktop 2022.4 or later.Option 2
- Follow the steps in Copy and Paste Sheets to copy the sheet into a new blank workbook. The steps are outlined here for convenience:
- Create a new blank workbook.
- Open the workbook that contains the sheet you are going to copy from and select the Filmstrip button in the status bar.
- Select the thumbnail of the sheet you want to copy, then right-click (Control-click on Mac) and select Copy.
- In the new blank workbook, right-click (Control-click on Mac) on the tab for any sheet, and select Paste.
- 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.
- In the new workbook, replace the original data source for the copied worksheet with the new desired data source. The steps are outlined here for convenience.
- Select Data > New Data Source and then connect to the new data source.
- On the Data Source page, drag a table to the canvas to set up the data source.
- Go to the sheet tab and select Data > Replace Data Source.
- In the Replace Data Source dialog box, select the Current data source and the Replacement data source.
- Under the Current field, select the checkbox to replace the current worksheet only and select OK.
- 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.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials