Excel Application scope Read Range PreserveFormat error

Scenario:If I open a file that has links in it and select PreserveFormat it removes the links and the data is filled with ######'s

Steps to reproduce:Read a Range that includes links to other sheets in the workbook, Select PreserveFormat and output to a DataTable.

Current Behavior: the format is preserved and the actual data is lost.

Expected Behavior:I would expect to be able to retain the data and the formatting

Studio/Robot/Orchestrator Version:2019.4.2

Last stable behavior:
Last stable version:
OS Version:Windows 10
Others if Relevant: (workflow, logs, .net version, service pack, etc):

Hi @cmrobertson,
Can you tell me which excel activities package version do you have? Have you tested with older/newer version?


I am using Excel activities pkg 2.5.3 I downgraded to 2.5.1 issue still exists

We will take a closer look into this.