Excel solvertable error

Alexey11226 1 Reputation point
2021-12-17T08:42:08.49+00:00

Every time I am running solvertable in Excel, I got a message: Error number 13 Type mismatch

Does anyone knows how to fix it?

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,638 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 21,626 Reputation points Microsoft Vendor
    2021-12-20T07:32:52.127+00:00

    Hi @Alexey11226 ,
    Normally the error occurs when you try to assign a value between two different variable types. Did you check the data you're using in Excel?
    How did you run the add-in?
    Do you need to add some values?
    Please be a bit more precise to explain your requirement or you can upload a screenshot so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.

    If the response is helpful, please click "Accept Answer" and upvote it.
    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.

  2. Mancero Villareal, Julio C 0 Reputation points
    2023-01-19T03:35:14.8133333+00:00

    I have the same problem. I have built a spreadsheet model and have used Solver without any problem. When trying to use SolverTable, I´m getting the same error.

    Already verified the decimal and thousands separators and they are point and comma recommended, as you recommended.

    After clicking OK on the error message, a series of blank tables are generated (see attachment)..