Share via

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?

Microsoft 365 and Office | Excel | For business | Windows
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff
    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)..

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.