Skip to main content
G
GR_130784821-Visitor
1-Visitor
April 1, 2025
Solved

Variable access in included (reference) sheet

  • April 1, 2025
  • 1 reply
  • 439 views

I am using an include statement to include calculations and values from a reference sheet in my main Mathcad document.

 

Is there a way to get access to variables defined in the parent document in the reference document? For example, if I define a variable called "mass" in the parent document, and then I have an expression in the referenced document that multiplies mass by 2, as in: double_mass := mass * 2, will that work? 

 

Right now, I am only able to use variables in the reference sheet that have been defined in that sheet. I do note that functions and variables defined in the reference sheet are available in the parent sheet following the include statement, as expected.

Best answer by Werner_E

The worksheet you include can use all variables from the parents sheet which are defined in front of the "Include" region.

But when you edit the include sheet, these variables will be unknown and so you will see an error message. Nonetheless the combination from parent sheet and included sheet will work OK.

Example;

Included sheet (Incl.mcdx) contains

Werner_E_0-1743512047494.png

It throws an error as of x not being defined.

The parents sheet works OK, though:

Werner_E_1-1743512173074.png

 

An included worksheet acts as if the containing commands would be written in the parents sheet at the position of the "Include".

 

 

 

 

1 reply

W
Werner_E25-Diamond IAnswer
25-Diamond I
April 1, 2025

The worksheet you include can use all variables from the parents sheet which are defined in front of the "Include" region.

But when you edit the include sheet, these variables will be unknown and so you will see an error message. Nonetheless the combination from parent sheet and included sheet will work OK.

Example;

Included sheet (Incl.mcdx) contains

Werner_E_0-1743512047494.png

It throws an error as of x not being defined.

The parents sheet works OK, though:

Werner_E_1-1743512173074.png

 

An included worksheet acts as if the containing commands would be written in the parents sheet at the position of the "Include".

 

 

 

 

Terms & ConditionsCookie settingsAccessibility statement