Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
> ... Every time I try to run it ...
< deleted, no response >
Excel 2016 Solver Problem
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
Hello,
I am having trouble to use Solver on my excel sheets. Every time I try to run it this message appears "Microsoft Visual Basic. Run-Time error '1004'. Application-defined or object-defined error".
I already did a full repair and also reinstall Office.
What can I do to fix Solver?
Thank you,
Guilherme Frizado
Microsoft 365 and Office | Excel | For home | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
2 answers
Sort by: Most helpful
-
Anonymous
2019-10-08T13:21:10+00:00 -
Anonymous
2019-10-08T12:51:54+00:00 Hi Guilherme,
Sorry for the inconvenience caused by this issue.
Based on your description, this error happened when using Solver add-in and VBA. As the issue occurred with Excel add-in. We want to help but we sincerely suggest you contact Solver Supportto find the professional solution and resolve it soon. It’s the most convenient way to let you work normally.
However, you can try these ways inthis articleto check the result, it may give some help. Thanks for your understanding.
Best Regards,
Ivy