Losing Formulas in Excel when inserting Collection

[NiklasFranke]

Hello,

currently i am facing the problem, that when in get values from an Excel as collection and insert it back, the Excelsheet loses all Formulas, which would be normally there in the cells.

Is there any way to preserve the Formulas or do i need to recreate these in Blue Prism?

[harish.m]

Hi niklas franke,
Did you tried below suggestions mentioned in this thread?

https://community.blueprism.com/communities/community-home/digestviewer/viewthread?GroupId=145&MID=5123&CommunityKey=3743dbaa-6766-4a4d-b7ed-9a98b6b1dd01&tab=digestviewer

[Mukeshh_k]

Hi, Refer - https://community.blueprism.com/discussion/losing-formulas-in-excel-when-inserting-collection?ReturnUrl=%2fcontent%2fallrecentposts for the answered thread.

Regards,
Mukesh