Skip to main content
K
keizow496627
February 17, 2026
Question

Available Excel version for Export Data Store Entity to Excel Smart Service

  • February 17, 2026
  • 1 reply
  • 0 views

Hi everyone,

When I exported data using "Export Data Store Entity to Excel" from a proprietary Excel workbook that contains formulas, the Excel formulas get corrupted.

Is there any limitation on the Excel workbook version that can be used with "Export Data Store Entity to Excel"? I am using Excel 365.

Symptoms:

(1) Formulas are shown as text and no longer calculated, for example:
_xlfn.VSTACK({""}, _xlfn._xlws.FILTER(category!J2:J1001, TRUE, ""))
IF(A9=0,,SUM(A9:B9))
(2) Japanese phonetic (furigana) information appears in the same cell.

    1 reply

    shubhama926776
    shubhama926776
    February 17, 2026

    Export Data Store Entity to Excel explicitly does not support Excel formulas in templates/output.
    Use templates without formulas, or add formulas manually after export or RPA post-processing are standard recommendations.

    Check all unsupported excel format and elements
    https://docs.appian.com/suite/help/26.1/Export_To_Excel_Smart_Service.html#unsupported-excel-formatting-and-elements

    Terms & ConditionsAccessibility statement