Skip to main content
1-Visitor
October 7, 2015
Question

Excel to MathCAD Slow Runtime

  • October 7, 2015
  • 0 replies
  • 709 views

Hi all,

I have a macro that takes data from Excel and places the data into a MathCAD object within Excel. The MathCAD sheet then recalculates and spits out an answer back into Excel.

Here is the problem: I can open Excel, push "Run", and the data gets spit out in about 20 seconds, but if I hit Run again (whether the data changes or not), the processing time increases to about 90 seconds. Obviously this is not preferred for a lot of data.

I've tried to open & close the tab in a different workbook, but then my macro doesn't recognize the MathCAD object.

Any ideas on how to cut down the runtime?