Overwrite data in Excel cell that contains formula and keep the cell formula Intact

Question

Hello Community,

I am working on the scenario where an input file contains the employee information and needs to map the employee information with another file and map the value in row fashion.

I am able to map value but the only challenge is when I am overwriting the data in the file that file contains formulas in the cells and throwing an error " Output Data (41) Error: Unable to overwrite a cell that contains a formula: I12. Adjust your range to avoid formula overwrite."

Is there anyway I can keep the Formula intact in the excel file ?

please find the attached solution that I have built.

Data_mapping.yxzp

Chhamanshu · Answer

What if we have more that 4000 columns and not sure in which cell excel formula is written then in that case creating a range manually will be a tedious task and it won't work.

glenebb · Answer

You could create a range in excel (lets use 'RangeName') and output just to that range: filename.xlsx|||RangeName

This would allow you to keep any formulas you might have in the sheet.