There is no way to use a workbook as a data source. Can you not point to the actual data source?
If it is a TWBX, you can change the extension to a .ZIP, and open it as a compressed file, and remove the data and save it seperately, but there is no automated way to do it "Out of the Box"
Also, this method is no supported at all by Tableau
Oh hi Mark
Unfortunately I can't point to the original data because it's from a third party vendor.
However, I think I figured it out--simply selecting "more" in the "Connect to a File" menu lets me select the workbook and then extract individual data sources from the workbook itself, which, I believe, will solve my problem in the future.
I'll update this if it does or doesn't. In the meantime any other solutions or workarounds would be appreciated as well! Thanks!
that reference is not lost on me... LOL
The problem with referencing the workbook, it that it looks to grab all the settings, then want to direct to the original source (at least what I have experienced).
Let me know if you find different results.