Sheet Information Support in Planning

Table 7. Sheet Information Supported by Planning

Connection Status

Form

Ad Hoc

VBA

Rules

Functions

Shared ConnectionYesYesYesYes No
Private ConnectionYesYesYesYes No
Private Connection—Set as Default ConnectionYesYesYesYesNo
No Connection, open new blank worksheetNoNoNoNoNo
No connection, open a saved worksheetYesYesYesYesNo
Set Active Connection for this WorksheetYes (see Sheet Information Notes)Yes (see Sheet Information Notes)YesYes No
Set as Default Connection, before associate with active connectionNot applicable (see Sheet Information Notes)Not applicable YesNot applicable Not applicable
Set as Default Connection, after associating with active connectionYes (see Sheet Information Notes)YesYesYesNo