06-07-2021 03:09 AM
Error: Output Data (96): Error: Unable to overwrite a cell that contains a formula: AM24. Adjust your range to avoid formula overwrite.
Thanks for this @MariaW.
I was trying to write overwrite a single cell in a spreadsheet and it baffled me until I found your post! My workflow now runs without an error and updates the cell, but on opening the excel file it opens in repair mode - any ideas how this can be avoided?
@DavidP
Might it be a data type problem? Alteryx thinks =8.25 is a string, but in Excel it gets treated as a number. I think the restriction on overwriting formulas was implemented after the Preserve Formatting issues were ironed out, but it might be worth looking at.
Thanks @lepome
The problem seems to be resolved. Not sure what I did but I seemed to have introduced the problem outside of Alteryx or through various attempts tp overwrite the formula cell. Once I reverted to a clean file it was all good. Thanks for your help.
Conceptually i understand the issue and how to fix, can anyone show me practically how to get this done within a workflow?