Power Query Problems

Fix Excel Power Query Not Showing or Opening XLSB Tables

Phi Hung VoPhi Hung Vo Nov 14, 2026 868 views

Question details

The user needs Excel Power Query to display and open tables from an XLSB workbook.

Fix Excel Power Query Not Showing or Opening XLSB Tables
Product
Microsoft Excel Power Query
Device & OS
not provided
Scenario
Importing tables from an XLSB workbook through Power Query Navigator.
Observed behavior
Some Excel versions do not show XLSB tables in Navigator or display the error “External table is not in the expected format,” while XLSM sources work.
Before you start

Confirm that the source workbook opens normally in Excel and identify the tables you expect to see in Navigator. Note your Excel version under File > Account so you can compare results after updating.

Solution 1Recommended

Update Excel and retest the XLSB workbook

Use this first to check whether an Excel update resolves the issue in your version.

1
Check for updates

In Excel, select File > Account > Update Options > Update Now. If Update Options is unavailable, contact your administrator or check how your Office installation is updated.

2
Retry the import

Restart Excel, then select Data > Get Data > From File > From Workbook and choose the XLSB file. Check whether its tables appear in Navigator or the error still occurs.

Update Excel and retest the XLSB workbook
Results may vary: XLSB behavior can depend on the Excel version and the workbook. An update may not resolve every missing-table or file-opening issue.
Free Microsoft Office alternative

Work with Excel-format spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for everyday spreadsheet work. Its Excel-format compatibility can make it easier to move existing files into WPS, though it does not fix Microsoft Excel Power Query issues.

Open and edit Microsoft Excel XLSX spreadsheetsReview spreadsheet data in a familiar interfaceUse a free, lightweight office suiteMove existing Excel-format workbooks into a familiar workspace
microsoft office alternative - wps office

Frequently Asked Questions

Why are XLSB tables missing from Power Query Navigator?

This has been reported with some Excel Power Query versions and may depend on the workbook. Update Excel through File > Account > Update Options > Update Now, then test the source again.

What can I do about the external table format error?

First, check that the XLSB workbook opens in Excel. If Power Query still reports “External table is not in the expected format,” try saving the source as XLSM or XLSX and import that file through Data > Get Data > From File > From Workbook.

Should I save the source as XLSM or XLSX?

Use File > Save As and choose XLSM if the workbook contains VBA macros you need. Choose XLSX if macros are not needed; XLSX does not retain VBA macros.

How do I report an XLSB import problem to Microsoft?

In Excel, select Help > Feedback. Include your Excel version, the import steps, the exact error or missing-table behavior, and sample-file details that you can safely share.