Referencing worksheets

Forum|Forum|11 years ago
October 30, 2014
8 replies
2624 views

Hello all,

I am pretty new to Mathcad and still in learning stage. I have two seperate mathcad files created by different people. I need to cross refer variables from one file to another. I tried to use "Reference" option available under Insert. But since the files where created by different people, there are few common variable names in these two files so they are overwritten. Is there an option in Mathcad where we can send and receive just few variables from other mathcad file??

Thanks in advance

Deepak

Other

Werner_E

25-Diamond I

Deepak Somasundaram wrote:
Hello all,
I am pretty new to Mathcad and still in learning stage. I have two seperate mathcad files created by different people. I need to cross refer variables from one file to another. I tried to use "Reference" option available under Insert. But since the files where created by different people, there are few common variable names in these two files so they are overwritten. Is there an option in Mathcad where we can send and receive just few variables from other mathcad file??

Unfortunately, no. A reference acts as if the whole content of the referenced worksheet is copied into the current sheet. So the last definition of a variable "wins".

S

StuartBruff

23-Emerald V

One possibility is to add some new variables in between the References to store the values that have duplicate names.

Another possibility, if there are only a few variables, is to write the data to files and then read them back into your worksheet.

Stuart

P

ptc-3134225

Author

1-Visitor

I tried renumbering, but have lot of index to the variables and it might take more time. Regarding the second option, I am not sure how it can be done. I have couple of inputs in worksheet A which has to be transfered to sheet B and the results from sheet B has to be used sheet A for more calculations.

M

MikeArmstrong

1-Visitor

Deepak Somasundaram wrote:
Hello all,
But since the files where created by different people, there are few common variable names in these two files so they are overwritten. Is there an option in Mathcad where we can send and receive just few variables from other mathcad file??
Thanks in advance
Deepak

If the variable names you actually want to cross reference are different then I think it would be possible.