\
\

Sets or returns the caption displayed in place of an error.

\
 public System.String FriendlyErrorCaption{ get; set; }
\
Public Property FriendlyErrorCaption() As String
\

          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Open(@"C:\MySpreadsheet.xls");
          Worksheet ws = wb.Worksheets[0];
          ws.PivotTables[0].PivotTableSettings.FriendlyErrorCaption= "ErrorCell";
        

          Dim xla As New ExcelApplication()
          Dim wb As Workbook = xla.Open("C:\MySpreadsheet.xls")
          Dim ws As Worksheet = wb.Worksheets(0)
          ws.PivotTables(0).PivotTableSettings.FriendlyErrorCaption= "ErrorCell";
\

FriendlyErrorCaption is only displayed when ShowFriendlyErrorCaption is true.