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?
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
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