Skip to main content
J
jdesai-21-Visitor
1-Visitor
September 18, 2017
Question

What does the include function do? (Reference worksheets)

  • September 18, 2017
  • 2 replies
  • 3651 views

 

Untitled111.pngHello,

When I use the include function I get a window, where I can point to a path/file. Then I get a big green exclamation mark. Is this function supposed to do something? I did hit F1 but that did not have much info there. I thought the entire worksheet would show up. 

 

PS. It has a red border, because I altered the path, to comply with our company's procedures.

2 replies

F
Fred_Kohlhepp23-Emerald I
23-Emerald I
September 18, 2017

When you include a reference to a worksheet, you effectively put the entire worksheet at the point where you insert the reference; all of the functions and values of variables defined in the reference sheet are now available and live in the present sheet below the reference.

 

The reference does not appear, but its calculations are now availble.

J
jdesai-21-VisitorAuthor
1-Visitor
September 18, 2017

how do I get the worksheet to show up? I want to "insert" one worksheet into another to have a combined worksheet

F
Fred_Kohlhepp23-Emerald I
23-Emerald I
September 18, 2017

If  you double-click the reference, the referenced sheet will open; but there is no easy way to actually copy and paste the referenced sheet into another sheet.

 

You might experiment with PDF and XPS files and see if you can insert the fields that way; but  it won't be a live, calculating document.

 

You might put part of the referenced sheet into an area, colapse the area, copy it and paste it into the new sheet, then open the area. . ,.  There have been a lot of innovative approaches tried, with varying degrees of success.

-
-MFra-21-Topaz II
21-Topaz II
September 28, 2017

If you use MC15, referring to the "reference" you must follow the following structure:

About references.jpg
If, instead, you use "PRIME-4", you should observe the following rules:

About include.jpg

L
LucMeekes23-Emerald IV
23-Emerald IV
September 28, 2017

As long as worksheet B does not include worksheet C, there's no problem to include both worksheet B and worksheet C into worksheet. Extend this strategy when worksheet C includes worksheet D... etc.

Bottom line: when building a structure of worksheets intended for inclusion, be sure that upon usage (actual inclusion) every worksheet is only included once (so either included directly, or included indirectly, not both at the same time.)

 

Success!
Luc

 

Terms & ConditionsCookie settingsAccessibility statement