Forum Discussion

Copper Contributor

Jun 13, 2025

Excel 2024 stops responding with macro workbook from previous Excel version

Hello, I have an issue related to contract work I do. The main contractor creates a workbook that has macros for several rows in the workbook. I've used these workbooks for years running Excel 2016...

admin

community

developer

Formulas and Functions

Macros and VBA

Office Scripts

Kidd_Ip

MVP

Jun 15, 2025

Below step may help:

Recompile Macros

Open the Visual Basic Editor (Alt + F11), go to Tools > Options enable Compile On Demand, then restart Excel.

JLoy249
Copper Contributor
Jul 01, 2025
Compile on Demand was already enabled. The problem I'm having did not happen with my old laptop and Excel 2016. Both laptops are running Windows 11.
JLoy249
Copper Contributor
Jul 01, 2025
Compile on Demand was already enabled. Do you know of anything else to try? This is not an issue with Excel 2016.