Pivot Sheet Column Name Changes

Andy Lorance
Andy Lorance ✭✭✭✭
edited 06/14/22 in Add Ons and Integrations

Greetings -

I'm experiencing some inconsistencies between my Pivot Sheets relating to column name changes. The pivot process adds "Grand Totals-SUM-" as a prefix to the column name. I remove it and run the process again. The pivot process works fine on some sheets (data loads as-expected). However, brand new columns are inserted on other sheets with the "Grand Totals-SUM-" again. I rename them one more time and run the process ... same results. I cannot seem to find the rules for renaming the columns. I did see a suggestion for using helper columns pointing to the source, then hiding the source columns, but I don't want to do that if I don't have to.

Thanks in advance!!!

Best Answer


  • Andy Lorance
    Andy Lorance ✭✭✭✭

    Got it. I tried this again and it seems to be working now ... must have been a fluke.

    Thanks for the help!!!


  • Genevieve P.
    Genevieve P. Employee Admin
    edited 11/04/20

    Very strange! Glad to hear it's working now though.