Data Validation Crashing Excel

Question

I try to change the "Error Alert" for Data Validation and it immediately crashes Excel. I'm using Office 365 on a Mac. Never had this issue before.

Excel crash report is at the paste bin URL address below:

http://pastebin.com/Y6y5aY0U

Any idea why this is happening? I should mention this is also a very large spreadsheet.

Answer 1

Hi, good news! The fix for this issue is available in any builds 15.29 (161108) or greater. It has now released to all users. Please update your Office and let us know if you continue to encounter any issues.

Freya

Office Newsroom

Answer 2

This fix has now shipped to Insider Slow as well.

Answer 3

Hi, good news! Looks like this fix is working its way through the release channels. It is available in any builds 15.29 (161108) or greater. Currently this is available to Insider Fast only.

Insider Slow and Production can anticipate the fix being released next month hopefully. Thank you for your patience.

Freya

Office Newsroom

Answer 4

Hi, we are aware of a bug where working around the data validation dialog in the data tab is causing an Excel crash. The Excel team has a fix for this, which we are working on getting tested and released. I will let you know when I have more information.

Freya

Office Newsroom

Answer 5

Hi Edwin,

Did you recently install any updates on your computer?

To troubleshoot this concern, please check out and try the steps from this article: Fixes or Workarounds for Recent Issues in Excel for Mac.

You can also check out the steps done on this link: Office 2016 for Mac Won't Stop Crashingfor additional reference.

We're here for your feedback.

Regards.