cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can Bookmark boards, posts or articles that you'd like to access again easily! X

How to make an Excel file live within a Mathcad file

Digger28
1-Visitor

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.

ACCEPTED SOLUTION

Accepted Solutions
RichardJ
19-Tanzanite
(To:Digger28)

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 solution in original post

3 REPLIES 3

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

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?

RichardJ
19-Tanzanite
(To:Digger28)

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

Announcements

Top Tags