Table 5. Sheet Information Supported by HFM
Connection Status | Form | Ad Hoc | Formulas | VBA | Functions |
|---|---|---|---|---|---|
| Shared Connection | Yes | Yes | Yes | Yes | |
| Private Connection | Yes | Yes | Yes | Yes | |
| Private Connection—Set as Default Connection | Yes | Yes | Yes | Yes | |
| No Connection, open new blank worksheet | No | No | No | No | No |
| No connection, open a saved worksheet | Yes | Yes | Yes | No | |
| Set Active Connection for this Worksheet | Yes | Yes | Yes | No | |
| Set as Default Connection, before associate with active connection | Yes | Yes | Yes | No | |
| Set as Default Connection, after associating with active connection | Yes | Yes | Yes | Yes |