My data isn't displayed correctly while using the Office Excel Macro

[Riquet Aouad]

After uploading and displaying the excel sheet using the Office Excel Macro, cells with CONCAT or CONCATENATE formulas are resulting in "#NAME?" or #VALUE!" instead of showing the actual value (that can be seen normally prior to uploading)

Any advice on how to fix this?

[Ryan Kearney]

As a workaround you should be able to copy the sheet, then paste the sheet as values rather than as formulas. https://support.office.com/en-us/article/paste-values-not-fo…

[Ryan Kearney]

Did this resolve your issue? If so please mark the ticket answered. If not let me know and we can work around it. Thank you!