How to Convert XLSB to XLSX Faster Using Excel VBA
Question details
The user needs to reduce the processing time when using an Excel VBA macro to batch convert around 100 XLSB files into the XLSX format.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Running a VBA script to open, convert, and save multiple XLSB workbooks as XLSX files in bulk.
- Observed behavior
- The batch conversion process is taking over an hour because Excel redraws the screen, recalculates formulas, and triggers workbook events for every single file it processes.
Confirm whether your subsequent data workflow strictly requires the XLSX format, as alternative data extraction tools can natively read XLSB files much faster without any conversion.
Optimize VBA Settings for Faster Execution
Temporarily disable resource-heavy application features like screen updating and automatic calculation during the macro's execution.
When Excel opens and saves workbooks in a loop, it normally redraws the visual interface and recalculates all formulas. By disabling these background operations at the start of your script and re-enabling them at the end, your macro can run entirely in the background, which dramatically cuts down processing time.
Press Alt + F11 to launch the Visual Basic for Applications editor and navigate to the module containing your batch conversion script.
At the very beginning of your Sub routine, add the following code block: Application.ScreenUpdating = False, Application.DisplayAlerts = False, Application.EnableEvents = False, and Application.Calculation = xlCalculationManual.
At the end of your script, right before 'End Sub', add the reverse code block setting the first three properties back to True, and Application.Calculation = xlCalculationAutomatic.

Load XLSB Files Directly with Power Query
Bypass the need to convert the files entirely by using Power Query to directly read and combine data from the XLSB files.
Boost Your Spreadsheet Productivity with WPS Office
If dealing with heavy XLSB files, slow macro execution, or frequent format conversions is slowing you down, consider switching to WPS Office. It provides a highly compatible, fast-loading, and lightweight alternative to Microsoft Office that natively handles massive datasets and complex spreadsheet formats with ease.
- 1. Download and Install: Visit the official WPS Office website to download and install the free suite.
- 2. Open Your Spreadsheets: Directly open your XLSB, XLSX, or CSV files in WPS Spreadsheet without worrying about formatting loss.
- 3. Enjoy Seamless Editing: Utilize advanced formulas, pivot tables, and familiar spreadsheet tools immediately.

Frequently Asked Questions
Why does converting XLSB to XLSX take so long using a VBA macro?
By default, Excel visibly opens each workbook, recalculates all active formulas, and triggers background events for every single file. When processing dozens of files, these UI and calculation tasks compound heavily, causing massive processing delays.
Can I analyze data in XLSB files without converting them to XLSX?
Yes. If your goal is data analysis or consolidation, built-in tools like Power Query can natively connect to and read XLSB (Excel Binary Workbook) files. This allows you to skip the time-consuming conversion process entirely.
What happens if my macro crashes while ScreenUpdating is set to False?
If your macro terminates due to an error before reaching the code that restores your settings, your Excel application might appear frozen or fail to show updates. It is highly recommended to use structured VBA error handling to route the code to a cleanup section that restores Application.ScreenUpdating to True before exiting.




