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?
