Office
Sign in

Excel 2016 crashes when calculating user-defined XLL functions after a macro button was used in an already closed workbook

Important: This issue is now closed with the fix indicated below. For more information on other recent issues for your application, see Fixes or workarounds for recent Office issues.

Last Updated: December 13, 2017

ISSUE

If you use a button in a worksheet to start a macro and later close this workbook, subsequent attempts to calculate user-defined functions provided by an XLL add-in might crash. This impacts Monthly Version 1608 (Build 7301.xxxx).

STATUS: FIXED

This issue is fixed in Monthly Version 1708 (8431.2017) or higher. To get the latest updated immediately, open any Office 2016 app and choose File > Account > Update Options > Update Now.

For MSI based installations, use the latest patch for Excel that is available through Microsoft Update. For more information, see Office Updates.

More Resources

Icon Experts (brain, gears)

Ask the experts

Connect with experts, discuss the latest Excel news, updates, and best practices, and read our blog.

Excel Tech Community

Icon Community

Get help in the community

Ask a question and find solutions from Support Agents, MVPs, Engineers, and other Excel users.

Excel Forum on Answers

Icon feature request (light bulb, idea)

Suggest a new feature

We love reading your suggestions and feedback! Share your thoughts. We're listening.

Excel UserVoice

See Also

Fixes or workarounds for recent issues in Excel for PC

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×