Skip to main content
Digger281-Visitor
1-Visitor
Aug 15, 2014 5:50 PM UTC
Solved

How to make an Excel file live within a Mathcad file

I have imported an Excel file into Mathcad. I want to be able to change values in Excel and then those same values automatically update within Mathcad. I know you can do this with scripting, but I am not very good at writing code. I have attached the files to the discussion. Any help would be greatly appreciated.

RichardJAnswer
19-Tanzanite
Aug 15, 2014 9:10 PM UTC

See my answer (under a different user ID) from almost 12 years ago:

http://communities.ptc.com/message/39865#39865

(note my own reply to myself)

Maybe in another 12 years PTC will have given us the ability to link to the file directly

View in thread

3 replies

ValeryOchkov24-Ruby IV
24-Ruby IV
Aug 15, 2014 7:30 PM UTC

Use please the Properties (rright mouse click) and change regions in Excel sheet (A2:B4 etc) for inpot and output values.

Translate
Werner_E
Werner_E25-Diamond I
25-Diamond I
Aug 15, 2014 8:15 PM UTC

Valery Ochkov wrote:

Use please the Properties (rright mouse click) and change regions in Excel sheet (A2:B4 etc) for inpot and output values.

Why do you think that this will make the mathcad sheet reflect changes made to the original Excel file?

Translate
RichardJ19-TanzaniteAnswer
19-Tanzanite
Aug 15, 2014 9:10 PM UTC

See my answer (under a different user ID) from almost 12 years ago:

http://communities.ptc.com/message/39865#39865

(note my own reply to myself)

Maybe in another 12 years PTC will have given us the ability to link to the file directly

Translate
    Terms & ConditionsAccessibility statement