I am trying to use VBA to show the details within a Pivot Table.

My code is:
With Sheets("Pivot_Table").PivotTables("PivotTable2").T ableRange1
.Cells(.Rows.Count, .Columns.Count).ShowDetail = True
End With

I am doing this with several different pivot table files and the above code works without any errors on the other files but only on one file I receive the error, "Unable to set the ShowDetail property of the Range class"

Any suggestions on how to fix this?