Skip to main content
ptc-31342251-Visitor
1-Visitor
Oct 30, 2014 7:04 PM UTC
Question

Referencing worksheets

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

8 replies

Werner_E
Werner_E25-Diamond I
25-Diamond I
Oct 30, 2014 7:21 PM UTC

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".

Translate
StuartBruff23-Emerald V
23-Emerald V
Oct 30, 2014 7:36 PM UTC

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

Translate
ptc-31342251-VisitorAuthor
1-Visitor
Oct 30, 2014 8:13 PM UTC

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.

Translate
MikeArmstrong1-Visitor
1-Visitor
Oct 30, 2014 7:31 PM UTC

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.

Translate
ptc-31342251-VisitorAuthor
1-Visitor
Oct 30, 2014 8:14 PM UTC

Variable names what needs to be cross refered and few other variable names are same.

Translate
MikeArmstrong1-Visitor
1-Visitor
Oct 30, 2014 8:15 PM UTC

Can you provide an example or the actual worksheets for us to have a look at?

Translate
Terms & ConditionsAccessibility statement