Excel.PivotTable.ErrorString.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
PivotTable.ErrorString property (Excel)	vbaxl10.chm235109	vbaxl10.chm235109	Excel.PivotTable.ErrorString	7f00d151-9f92-a3b3-c95f-60c0600cf594	05/08/2019	medium

PivotTable.ErrorString property (Excel)

Returns or sets a String value that represents the string displayed in cells that contain errors when the DisplayErrorString property is True.

Syntax

expression.ErrorString

expression A variable that represents a PivotTable object.

Remarks

The default value for this property is an empty string ("").

Example

This example displays a hyphen in cells that contain errors in the specified PivotTable report.

With Worksheets(1).PivotTables("Pivot1") 
 .ErrorString = "-" 
 .DisplayErrorString = True 
End With

[!includeSupport and feedback]