duplicated rows invalidates file

[Kmdkca]

If a sheet contains multiple rows with the same name, the Add-PivotTable invalidates the output file even that the columns are not used.
repro step:
Add a sheet with the two columns named the same.
New-Excel -Path C:\temp\test.xlsx | Add-PivotTable -WorkSheetName cases -PivotTableWorksheetName PT -PivotRows "col2" -Verbose -Passthru | Save-Excel -Path C:\Temp\outtest.xlsx
open outtest.xlsx in excel and it will try repair it