3 of 3 people found this helpful
There's no magic solution for effective exporting of data from Tableau...it's just not designed for this to be optimal. Exporting to Access is your best bet for large amounts of data. For Excel, the problem with Export CrossTab to Excel is that is does some formatting (data types, merging cells...etc.) which seem to take the bulk of the time. I'd recommend trying the Copy rather than export option, and then paste it into excel. This way it is just flat text and is much faster.
Hope that helps