Skip to main content
1-Visitor
Jun 10, 2015 7:27 PM UTC
Solved

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

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.

lhansenAnswer
1-Visitor
Jun 11, 2015 6:38 PM UTC

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

1 reply

lhansen1-VisitorAuthorAnswer
1-Visitor
Jun 11, 2015 6:38 PM UTC

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

Translate