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

Question

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 · Answer

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!

Ryan Kearney · Answer

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…