Troubleshoot Excel 2016 Power Query Connections to XLSB Workbooks
Question details
The user needs to resolve failures in Excel 2016 Power Query when connecting to binary .xlsb workbooks because of a local Office installation, a missing database component, or connector compatibility issues.

- Product
- Microsoft Excel 2016 Power Query
- Device & OS
- not provided
- Scenario
- The user is trying to use Power Query in Excel 2016 to connect to or import data from an XLSB workbook and needs the connection to complete successfully.
- Observed behavior
- Power Query cannot connect to XLSB workbooks. The failure affects the XLSB format rather than a single file and may be caused by Office, security software, database driver, or bitness issues.
Confirm the XLSB file opens normally in Excel and that you can access the file path. Test the same Power Query connection with a different XLSB workbook to determine whether the issue is file-specific or format-wide.
Confirm the XLSB workbook is accessible and isolate the failure
Use this first to determine whether the problem is limited to one workbook or affects all XLSB files.
Open the affected XLSB workbook directly in Excel 2016 and confirm that the file is not blocked, corrupted, or password-protected.
In Power Query, connect to a different XLSB workbook saved in a local folder to see whether the connection succeeds.
If possible, open the same XLSB file in Excel 2016 on another computer to confirm whether the issue follows the file or the installation.
Repair Office and temporarily disable security software
Use this when all XLSB files fail and the problem points to the local Office installation or an interfering security product.
Install a matching Microsoft Access Database Engine component
Use this when Excel is 64-bit but the installed database driver is 32-bit, or when the required connector component is missing.
Use WPS Office to Open and Edit XLSB Workbooks Without Power Query
WPS Office is a free, lightweight Microsoft Office alternative with strong Excel compatibility. It lets you open and edit .xlsb workbooks directly in its familiar spreadsheet interface and migrate existing Excel files without configuring Power Query connectors or database drivers.

Frequently Asked Questions
Why does Excel 2016 Power Query fail to connect to XLSB files?
The failure is often caused by a local Office installation problem, a missing Microsoft Access Database Engine, or a 32-bit/64-bit mismatch between Office and the installed database driver. Start by testing another XLSB file and checking your Office bitness.
How do I check whether my Office installation is 32-bit or 64-bit?
Open Excel 2016, click File > Account > About Excel. The version information in the About dialog shows whether Office is 32-bit or 64-bit.
Can WPS Office open XLSB files without Power Query?
Yes. WPS Office Spreadsheets can open and edit .xlsb binary workbooks directly, without requiring a Power Query XLSB connector or a separate database engine.
Should I install both 32-bit and 64-bit Microsoft Access Database Engine versions?
No. Install only the Microsoft Access Database Engine version that matches your Office bitness. Installing both can create conflicts that make the XLSB connection fail.
Does temporarily disabling security software help with Power Query XLSB connections?
It can help identify whether security software is blocking the connection. Disable security software only for a short test, then re-enable it immediately afterward.





