function CheckRobustConnect() {

    let pvtCache = Application.ActiveWorkbook.PivotCaches().Item(1).RobustConnect
									
    // Determine the connection robustness and notify user.
    switch(pvtCache) {
        case 1:
            MsgBox("The PivotTable cache is always connected to its source.")
            break;
        case 0:
            MsgBox("The PivotTable cache is connected to its source as required.")
            break;
        case 2:
            MsgBox("The PivotTable cache is never connected to its source.")
            break;
    }
									
}