Our users wants a simple way to export data to Excel. I came across this post on creating an image with a hyperlink:
The problem is that it exports the underlying data. I want the button to mimic the functionality of the screenshot below:
With this option, I get a clean representation of the data on the worksheet instead of the underlying data.
A workaround if you do not have Tableau Server would be to copy and paste the data into the program desired. Data copied from a sheet in this manner will always be pasted as a crosstab.
Hope this helps!