Tableau Desktop freezes when exporting data with the Worksheet > Export > Crosstab to Excel function and using a very large data set.
Generally, Tableau Desktop will not be responsive until Excel opens with the exported data.
For small data in the view, it takes seconds to complete export and Tableau Desktop freezes for a short time.
But when the data is large in the view(e.g. 1 million rows of data), Tableau Desktop can freeze for over 1 hour.