list boxes resize when sheet on auto recalc

S

Sonny Sachdeva

I'm running an option pricing spreadsheet that
automatically recalcs whenever the underlying price
moves. The sheet works well, except every once in a
while, the list boxes on the page will start resizing and
get down to almost no size at all. Usually at that
point, excel crashes.

Does anyone know the cause and/or fix of this? I've
spoken to others in the industry and they complain about
similar maladies.

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top