+ Reply to Thread
Results 1 to 3 of 3

Excel 2019 - Solver - Unexpected error or available memory was exhausted

  1. #1
    Registered User
    Join Date
    03-09-2022
    Location
    Belo Horizonte, Brasil
    MS-Off Ver
    2019
    Posts
    2

    Excel 2019 - Solver - Unexpected error or available memory was exhausted

    Hello, everyone.

    I trying to run a macro that is based on SOLVER code. It was working perfectly however now appears this following message: "Solver: An unexpected error occurred, or available memory was exhausted"

    It happen days ago and I solved it formatting my computer. But it happen again now and I think that it is not smart to format it again.

    The code is:

    Please Login or Register  to view this content.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Excel 2019 - Solver - Unexpected error or available memory was exhausted

    Hi and welcome to the forum.

    We can't help unless you upload the workbook, and when you do clearly explain what you are trying to achieve
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    03-09-2022
    Location
    Belo Horizonte, Brasil
    MS-Off Ver
    2019
    Posts
    2

    Re: Excel 2019 - Solver - Unexpected error or available memory was exhausted

    Hi Richard. Thanks!

    Unfortunately I canīt share this workbook once there are confidential information on it. But my point here is that this macro was working very well until today morning when suddenly this message came up and it is not working anymore.

    Main objective of this macro is to maximize some plants results using inputs values % of minerals and technologies.

    This problem showed first time after I change my computer. And to solve it I need to format this new one. And now it appeared again.

+ 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. Run time error in VBA Excel 2019
    By salmen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-12-2022, 02:11 PM
  2. Excel 2019 will NOT UTILIZE memory
    By carsto in forum Excel General
    Replies: 0
    Last Post: 04-19-2021, 09:27 AM
  3. I get the message:solver an unexpected error occured
    By nchinas in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-02-2014, 05:44 PM
  4. [SOLVED] Macro with Solver. An unexpected internal error occurred, or available memory
    By sofiaventura in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-26-2013, 04:24 PM
  5. Solver: An unexpected internal error occurred, or available memory
    By Chad in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-26-2013, 05:31 AM
  6. Replies: 1
    Last Post: 12-08-2011, 08:52 AM
  7. Replies: 0
    Last Post: 04-06-2006, 02:45 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