Using DrillDown Instances

Because DrillDown instances may be numerous and temporary, PS/nVision does not save them automatically as it does for parent instances. Also, since these instances are generated without a report request, there are no directory and file name templates. Therefore, PS/nVision performs the following operations when creating the instances:

1. Saves the layout as a temporary template sheet (DRILL.XLT) in your TEMP directory.

2. Opens an instance of the template; this causes Excel to assign a name such as DRILL1.

3. Populates the instance as usual but neither saves nor closes it. You can save it (assigning a name at save time) or close it without saving it once you are finished using it.