Sheet Information Support in Planning

Table 6. Sheet Information Supported by Planning

Connection Status

Form

Ad Hoc

Smart Form

VBA

Rules

Functions

Shared ConnectionYesYesYes Yes Yes
Private ConnectionYesYesYes Yes Yes
Private Connection—Set as Default ConnectionYesYesYes YesNo
No Connection, open new blank worksheetNoNoNoNoNoNo
No connection, open a saved worksheetYesYesYes YesNo
Set Active Connection for this WorksheetYes (see Sheet Information Notes)Yes (see Sheet Information Notes)Yes (see Sheet Information Notes)Yes (see Sheet Information Notes)Yes Yes (see Sheet Information Notes)
Set as Default Connection, before associate with active connectionNot applicable (see Sheet Information Notes)Not applicable Not applicable Not applicable Not applicable Not applicable
Set as Default Connection, after associating with active connectionYes (see Sheet Information Notes)YesYes YesYes