We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

XLSB File Crashes Designer

londonhanson
Alteryx
Alteryx
Created

Designer Crashes When Opening XLSB Files

 

Environment Details

 

If Windows 10 patches are not up to date on a machine, opening an Excel binary file (.XLSB) in an Input Data Tool crashes Alteryx Designer.
 

  • Alteryx Designer
    • 2022.1
    • 2021.4
  • Microsoft Excel binary files (.XLSB)
  • Input Data Tool
  • Windows 10


Cause

 

Windows 10 updates have not been installed. As an additional consideration, if you are unable to see .XLSB as an option in the "File Format" dropdown of the Input Data Tool, you will need to install the Microsoft Access Database Engine 2010 Redistributable (32-bit) as well, found here: 

https://www.microsoft.com/en-us/download/details.aspx?id=13255

 
image.pngimage.png
 


Resolution

 

Solution A

  1. Please update your computer to the latest Windows version, including any patches that may need to be installed.
  2. To check for Windows updates, select Start > Settings > Update & Security > Windows Update, and then select Check for Updates.image.pngimage.pngimage.pngimage.png
  3. Ensure that the machine is up to date.


Additional Resources