Share via

Help with Solver through Excel for a test about profit

Emrsn 20 Reputation points
2025-06-12T21:12:41.16+00:00

I am trying to use the Solver extension in my Excel to run through a test to gain the best profit but it isn't working. I've included a picture that shows the info I needed to include on the right, what I had put into the solver in the middle, and the information in Excel on the left. Help would be appreciated. Thanks!

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,936 questions
Accepted answer
  1. Dora-T 1,085 Reputation points Microsoft External Staff Moderator
    2025-06-13T02:36:34.3733333+00:00

    Hi @Emrsn

    I’m glad to hear you managed to fix the issue! I actually tried it myself and ran into the same thing, some of the Solver info disappeared. But after I entered all the information and saved the file, it didn’t happen again.

    To avoid this issue next time, you can:

    • Double-check that all referenced cells in Solver (Objective, Variable Cells, Constraints) are correct and complete.
    • Save your file after setting up Solver — that seemed to prevent the issue for me.

    I hope this helps. Feel free to let me know if you have any any further questions.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".  

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.