Hi all,
I had a nice little solver tool set up to help me plan out a production schedule. It has 6 constraints, and 2 variable cells. Typically it would reach a solution in under a second. All of a sudden it stopped working on me. I am not certain but I THINK it stopped working after I copied the sheet to a different workbook (using the move or copy sheet option from the context menu). It still works in the original workbook, but not the one I copied it into.
I'll hit "solve" and it will get hung up on the "setting up problem" phase. I have to end the task through windows task manager. Before it closes it pops up an error message reading "Automation Error Exception Occurred"
I don't really know what causes this error and I've checked all my formulas and such to make sure there aren't any messed up cell references. Not sure what else to try.
Ideas anyone?
Bookmarks