Overwrite data in Excel cell that contains formula and keep the cell formula Intact
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Input
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
