Hey Andrew -
There is a single supported way, and an unsupported technique, which I'll explain too. You should probably also ask yourself if you can't just re-create the worksheet against your new data source more quickly than using either of the two methods below
- Use the Bookmarks feature (Window | Bookmarks menu items) to create a bookmark for the view you want to modify.
- In a new, empty workbook, use Window | Bookmarks to import the worksheet.
- Replace the data source in the new workbook.
- In the new workbook, create ANOTHER bookmark with a slightly different name
- In the old workbook, delete the sheet you're working with AFTER you make a backup
- In the old workbook, use Window | Bookmark to import the "updated" worksheet back in
Lots of hoops!
Unsupported technique - Tableau workbooks are nothing more than XML. You should be able to figure out how to do a little bit of copying/pasting/replacing in order to update the data source for a single worksheet in the workbook if you open the workbook up in a text editor. Wait, don't do that - it's unsupported.
Hope this helps!