+ Reply to Thread
Results 1 to 5 of 5

Excel Solver: Not seeing reports nor report selections

  1. #1
    Registered User
    Join Date
    03-07-2013
    Location
    Long Beach, WA
    MS-Off Ver
    Excel 2013
    Posts
    87

    Excel Solver: Not seeing reports nor report selections

    I'm bringing workbooks that had been working in Excel 2010 or 2013 (not sure which) and using Solver and VBA.
    I'm in a serious debugging mode to get the system back up and running.
    I'm hoping that Solver problems might be helped with the "Reports". But I don't see how to ask for them!!
    In the Solver Results dialog, I see a blank box on the top right entitled "Reports" which is empty.
    In that same dialog, I see a checkbox labeled Outline Reports and I have that checked.

    Right now, I'm getting "All variables must have both upper and lower bounds." and I'm trying to fix that. It seems simple enough, if tedious.
    In a perfect world, I'd be getting a list of the bounds that are missing.
    I'm using Evolutionary and Require Bounds on Variables.

  2. #2
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    Re: Excel Solver: Not seeing reports nor report selections

    Perhaps this could be the problem? I've also had problem to access reports when my model has binary constraints as well as integers.

    Reports available when Solver finds a solution

    · In almost all cases where Solver finds an optimal solution, Solver converges to the current solution, or Solver cannot improve the current solution, the Answer Report is available. When the Evolutionary Solving method is used, its Population Report is also available. If Solver finds a (locally or globally) optimal solution, and there are no integer constraints, two additional reports are available: the Sensitivity Report and the Limits Report.
    Can you remove the constraint on upper and lower bound? I.e. Untick box marked "Require bounds on variable", will that allow you to run Solver?

    ev_lim.jpg

    Alf
    Last edited by Alf; 07-03-2023 at 11:10 PM.

  3. #3
    Registered User
    Join Date
    03-07-2013
    Location
    Long Beach, WA
    MS-Off Ver
    Excel 2013
    Posts
    87

    Re: Excel Solver: Not seeing reports nor report selections

    Thanks! I’ve not needed to use the Reports enough to be able to handily navigate. This helps!

  4. #4
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    Re: Excel Solver: Not seeing reports nor report selections

    My suggestions are guesstimates so in order to get the best possible help you should upload the file you have the problem with so members can do a bit of testing. Excel 2013 is that the Mac version of Excel? As there has been problem running the Excel Solver using VBA in the Mac environment.

    Alf

  5. #5
    Registered User
    Join Date
    03-07-2013
    Location
    Long Beach, WA
    MS-Off Ver
    Excel 2013
    Posts
    87

    Re: Excel Solver: Not seeing reports nor report selections

    I found it. Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Several reports into 1 report with daily updates?
    By Vihral in forum Excel General
    Replies: 26
    Last Post: 05-19-2016, 09:58 AM
  2. Replies: 1
    Last Post: 10-06-2015, 03:02 PM
  3. Reports in Solver not Appearing
    By scholl43 in forum Excel General
    Replies: 0
    Last Post: 02-02-2014, 04:27 AM
  4. Solver - Different Sensitivity Reports
    By Valentina_Lapp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-06-2007, 06:58 AM
  5. ATT: Debra D; no selections in report manager
    By herbzee in forum Excel General
    Replies: 1
    Last Post: 10-26-2005, 10:05 PM
  6. Replies: 7
    Last Post: 10-26-2005, 12:05 PM
  7. Replies: 0
    Last Post: 03-29-2005, 10:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1