Pivot App- Error! Column titles are not unique among input columns. (1133)

Dan Harris

I am unable to run a pivot due to above can you help?

Also dates are pulling into piviot app using US style not UK, any ideas?

Chris Mondeau

Hi @Dan Harris ,

I've run into this before with larger reports as the source for the pivot, which sometimes causes the pivot refresh to error out and create duplicates. My quick fix is to delete all columns, re-run the pivot, then just wait a few minutes for it to fully run before I view/edit the sheet.

Dan Harris

spotted the issue, was linked to columns not containing a date so pivot couldn;t calculate, filtered the report feeding the pivot to only include columns with dates not all good!

Thanks