KNOWLEDGE BASE

ž Character Not Recognized Connecting To Microsoft Excel 95 File


Published: 28 Apr 2017
Last Modified Date: 28 Apr 2017

Issue

When opening a legacy Microsoft Excel 5.0/95 (BIFF5) workbook in Tableau Desktop, ž character is not recognized correctly. 

Environment

  • Tableau Desktop 10.0.2, 10.2.1
  • Microsoft Excel 5.0/95 (BIFF5) .xls workbook.

Resolution

Option 1
Upgrade the format of the file to a higher version such as Excel 97-2003 (BIFF8) .xls workbook or higher. 

Option 2:
Open the file using the Microsoft Jet-based legacy connection: 
  1. Open Tableau Desktop. 
  2. Connect to a File > Excel 
  3. In the Open dialog box, by clicking the Open drop-down menu, and then selecting Open with Legacy Connection. 

Note: It is not possible to UNION Excel files when using the legacy connection. 
Did this article resolve the issue?