Excel Add-In Showing Cells with Strikethrough

When using the excel add-in to pull data from Anaplan, a seeming random number of cells are formatted with strikethrough though they are not formatted this way in Anaplan and the formatting is not on in Excel?

Answers

  • Can't say I've seen the same behaviour when using the add-in but makes me think there's existing formatting on the worksheet/workbook, which isn't being cleared.

    What do your settings look like and are you using a blank worksheet each time, or an existing worksheet?

    If you enable 'Apply Anaplan styling' and ensure 'Keep Excel formatting' is off, does it still give you the same issue?

    image.png
  • The page needs the calculations updated.

    Click F9 or in the Formulas tab click Calculate Sheet.