Error - "Microsoft Excel is trying to recover your information."

[MarvinP]

Has anyone seen this error before?

I have a large workbook with lots of VBA code in it. I know how to set breakpoints and step through code.
I have a Validation Dropdown that displays a List that is created by a Dynamic Named Range.

When I click on the validation dropdown arrow I get the following Error message and Excel ends up shutting down. I'd set a breakpoint if I knew where.

Hints, please... Here is the screen shot of just before Excel closes.

2016-07-28_9-06-29.jpg

[YasserKhalil]

This link may be useful for you
https://support.microsoft.com/en-us/kb/2735548

[MarvinP]

Hi Yasser,

Thanks for the link. I'm going through them now. The problem happens when I click the down arrow on the Validation List Dropdown. If I type a valid word into the validation cell, the code works fine. It crashes when I click on the dropdown arrow. The Dropdown List is from a Dynamic named Range of "=OFFSET(Scorecard!$AE$6,0,0,COUNTA(Scorecard!$AE:$AE)-4,1)". Does this extra info help with an answer?

I changed the Validation List to a normal range and the problem didn't occur. I changed it back to the same Dynamic Named Range and the problem seems to have gone away. I'm not sure what I've done to remove the problem. Now I still don't know what caused the problem.

[YasserKhalil]

May be using dynamic ranges using offset (which is volatile function) causes this problem ..So I think dynamic range is the enemy (like merge) of the vba codes ..
I think you can determine the range using the code itself instead of named ranges