×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Excel Analysis Feature not working with Interpolate

Excel Analysis Feature not working with Interpolate

Excel Analysis Feature not working with Interpolate

(OP)
Hello,

I am using an excel analysis feature to calculate a load of equations, where my inputs are parameters from various other analysis features...all that works fine.

The spreadsheet alone (not within pro/e) works fine, but when it is used within the feature one of the cells will not work, causing the final output (the solution) not to work.

The cell that falls over is using an Interpolate function, which is an add-in for excel (Engineering Functions). It simply interpolates from a range of existing values in a table to give me a value exactly for the value I have.

As I said, it works out of pro/e no problem, but in pro/e this interpolate function just throws up a #NAME? error.

Anyone got any ideas on this?

Regards,

Jon Reynolds

RE: Excel Analysis Feature not working with Interpolate

(OP)
OK,

Sorry this always happens, I post a question, then start to find the answers.

Well not a solution but a reason why its not working. The add-in Engineering Functions, does not show up in the excel work book that pro/e opens...therefore the cell containing "Interpolate:..." is not a recognised function.

Why would Excel outside pro/e have this function but not within pro/e? Its all on the same machine...?

 

Regards,

Jon Reynolds

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources