HELP - TREE - CHART - INDEX

Double clicking "INDEX" (A) will open a form with (3) ways to publish the index for the current chart.

The index is an Excel table that will display everyone on the chart's vital details. This is helpful if the chart only displays limited information or to use for further research.

1. PRINT (B) = This will open the Excel print preview screen.  The print area and margins will automatically be set to the default values when you use this option (see below for those settings). 

*This version of the print preview may not allow you to scroll thru multiple pages.

2. PDF (C) = You will be asked to give the file a name and where to save it. Once created the PDF should open up automatically in your default program. The print area and margins will automatically be set to the default values when you use this option (see below for those settings). 

*Any duplicate filename in the chosen directory will be overwritten.

3. EXPORT (D) = Transfer the index to a new Excel workbook. This new workbook will be independent of the Tree workbook.  You can sort and edit the index as you wish.  No macros will carry over to this new workbook. The initial page setup in the new workbook will be the default print area and margins below.

*The exported table will have hidden columns you can use for further analysis.