VBA & Macro Problems

How to Convert XLSB to XLSX Faster Using Excel VBA

Huma Ashraf ChHuma Ashraf Ch Oct 19, 2026 868 views

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.

How to Speed Up Batch Conversion of XLSB to XLSX with Excel VBA
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the VBA Editor

Press Alt + F11 to launch the Visual Basic for Applications editor and navigate to the module containing your batch conversion script.

2
Disable Application Settings

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.

3
Restore Application Settings

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.

Optimize VBA Settings for Faster Execution
Implement Error Handling: Always use an error handler (e.g., 'On Error GoTo ErrorHandler') to ensure these settings are restored to True if the macro encounters an unexpected issue and terminates early.
Free Microsoft Office alternative

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. 1. Download and Install: Visit the official WPS Office website to download and install the free suite.
  2. 2. Open Your Spreadsheets: Directly open your XLSB, XLSX, or CSV files in WPS Spreadsheet without worrying about formatting loss.
  3. 3. Enjoy Seamless Editing: Utilize advanced formulas, pivot tables, and familiar spreadsheet tools immediately.
Free, lightweight, and fast-loading alternative to MS OfficeExcellent compatibility with Microsoft Excel formats including XLSB, XLSX, XLSM, and CSVFamiliar user interface ensuring a seamless transition and zero learning curveBuilt-in tabbed workspace to effortlessly manage multiple spreadsheets simultaneously
microsoft office alternative - wps office

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.