How do I define the output range value for an Excel component?

[lhansen]

I am trying to use an Excel component to look up values for MathCAD calculations. I have been unable to get any sort of momentum, because MathCAD keeps returning the error "The range value specified is invalid." whenever I try to include an output variable. From two variables, exposure category and height, I want to look up a value for kz using the table. I am using MathCAD 15.0, and Excel 2013. MathCAD Help is no use, because that error message isn't even listed as a potential error message.

[lhansen · Accepted solution]

Nevermind. I was having a compatibility issue with Excel 2013. Saving Excel under an older format solved the problem.