Loading

Error "Error sending Crosstab to Excel" When Exporting View

Udgivelsesdato: Feb 20, 2025
Beskrivelse
When exporting a view using the Crosstab to Excel option, the following error might occur:
 
Error sending Crosstab to Excel

On Tableau Server, when running Download > Crosstab the following error may occur:
 
An unexpected error occurred

 

Cause

  • Excel must be installed on the computer running Tableau Desktop in order to export to it successfully.
  • A permission issue with C:\windows\system32.
  • When two versions of Microsoft Office are installed, Tableau Desktop might encounter difficulty determining which version to choose. 
  • Because each mark in the view corresponds to values in the underlying data, exporting a large crosstab to Excel may exhaust memory.
Løsning

Ensure that the following conditions are met:

  • Ensure that Microsoft Office is installed on the computer running Tableau Desktop. 
  • Work with the IT Team to determine if the file is "locked" especially if using a shared drive.
  • Work with the IT Team to allow Tableau access to the folder C:\windows\system32.
  • Remove or correct any invalid calculated fields in the workbook. See this article for additional information, Error "Invalid Field Formula"
  • If you have two different versions of Microsoft Office installed, run an installation repair on the version of Microsoft Office you do not want to use as the default version for exporting a crosstab. For more information, see Repair or remove programs at Microsoft.
  • Ensure that the computer you are using has sufficient memory to export all marks, or export a smaller subset of marks, especially if you are experiencing other memory-related errors. Temporary lack of memory may be resolved by restarting the PC.
 
Yderligere ressourcer
Error "Invalid Field Formula"
Download Views or Workbooks
Export crosstab of data in the view to Excel

If the above information does not assist, please contact Tableau Technical Support and provide clean Desktop logs as described in this article.

 
Vidensartikelnummer

001473682

 
Indlæser
Salesforce Help | Article