This article is part of the Replicon Gen2 knowledge base. If you’re looking for information on Replicon Gen3, which is the latest version of Replicon, please visit:

If your Report Excel Export Format user preference is set to .csv, when you export reports that include date values, those values will be treated as strings, not dates, in Excel pivot tables. Therefore you will not be able to group these values as you would be able to group dates.

To avoid this issue, set your Report Excel Export Format user preference to .xml (Excel XP or Greater). To do this:

  1. Log in to Replicon
  2. Click the Settings link (located in the top, right-hand corner of the page)
  3. Change the Report Excel Export Format from .csv to .xml (Excel XP or Greater)
  4. Click Save.