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

Dan Harris
Dan Harris ✭✭✭✭✭
edited 06/14/22 in Add Ons and Integrations

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
    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
    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!