In series 4 of the Excel Add-in, you can rename columns and rows via the Excel formula bar.

To rename a column or row header:

  1. Select the cell for a column header, in this example Q1 FY16.
    The formula for the selected cell displays. In this case:
    =CHOOSE(2, "5423690091", "Q1 FY16")
  2. Change the value in the last set of quotation marks.
Rename a column header in a worksheet.

When you refresh your connection, all cells go back to to their value in the Anaplan source model. This includes column and row headers.

Alternatively, to create headers that persist on refresh:

  1. Add new columns or rows outside of your connection.
  2. Enter names for your new column or row headers outside of your connection.
  3. Hide the row or column headers in your Anaplan connection.

If the Anaplan source data gains or loses columns or rows, headers created with this method become offset.

Disclaimer

We update Anapedia regularly to provide the most up-to-date instructions.