Skip to main content
1-Visitor
June 10, 2015
Solved

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

  • June 10, 2015
  • 1 reply
  • 2144 views

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.

Best answer by lhansen

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
June 11, 2015

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