1 ACCEPTED SOLUTION
Accepted Solutions
Hi Vladimir
Thanks for the reply, however it was not the cause, which I appear to have found now. The issue is that the Mathcad Prime 8.0 Excel component, unlike the Mathcad 15.0 Excel component, is sensitive to the order of the Excel worksheets within the workbook.
I found out by placing VBA code inside the Excel component and use the debug window to track the events during the calculation sequence. So it appears that Mathcad Prime first inputs the values to Excel and then activates the first work sheet of the workbook and calculates it (but not resolving dependencies, see Excel performance: Improving calculation performance). Mathcad walks through the remaining sheets in this way until it reaches the last sheet within the workbook. Then calculation continues in Mathcad.
The above algorithm should work fine if you have only one Excel worksheet in the Excel workbook, or if you line up your multiple Excel work sheets and their formulas, such that everything is calculated "from left to right". My Excel component had references between worksheets, and I thus kept getting incorrect results that would only converge at, say, the third instance of a force re-calculation in Mathcad (CTRL+F5).
This really is a bug, Mathcad Prime 8 should be updated to allow Excel to handle its own calculation and thus resolve dependencies.
See figure below and attachment using a very simple example.
Hi Vladimir
Thanks for the reply, however it was not the cause, which I appear to have found now. The issue is that the Mathcad Prime 8.0 Excel component, unlike the Mathcad 15.0 Excel component, is sensitive to the order of the Excel worksheets within the workbook.
I found out by placing VBA code inside the Excel component and use the debug window to track the events during the calculation sequence. So it appears that Mathcad Prime first inputs the values to Excel and then activates the first work sheet of the workbook and calculates it (but not resolving dependencies, see Excel performance: Improving calculation performance). Mathcad walks through the remaining sheets in this way until it reaches the last sheet within the workbook. Then calculation continues in Mathcad.
The above algorithm should work fine if you have only one Excel worksheet in the Excel workbook, or if you line up your multiple Excel work sheets and their formulas, such that everything is calculated "from left to right". My Excel component had references between worksheets, and I thus kept getting incorrect results that would only converge at, say, the third instance of a force re-calculation in Mathcad (CTRL+F5).
This really is a bug, Mathcad Prime 8 should be updated to allow Excel to handle its own calculation and thus resolve dependencies.
See figure below and attachment using a very simple example.
