unable to overwrite a cell that contains a formula M870

[imadorkous1]

I am trying to write to a cell range within a XLSX, but I keep getting the following error in the output:

When I go to the cell of M870 I see:

Is there a way to remove the "=" sign in Alteryx of that column? Or is there a way to search for any "=" in the data set? There shouldnt be any. The type of that column is supposed to be a V_WString, and I dont even know when there is a "=" sign in the first place. 

[Yoshiro_Fujimori]

Have you tried this?

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Unable-to-overwrite-a-cell-that-contai...

[imadorkous1]

Yes, I tried this but it didn't work

[Yoshiro_Fujimori]

I am not sure if the Designer version matters, but I am using 2023.1 (beta) now.

The workflow to overwrite a cell with formula ended normally, but the output .xlsx file needed repair.

When I opened the output .xlsx file, I got a message:

We found a problem with some content in 'Test.xlsx'.

Do you want us to try to recover as much as we can?

If you trust the source of this workbook, click Yes.

After clicking Yes, I got the message below:

The log file shows as below:

<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">

<logFileName>error107760_01.xml</logFileName>

<summary>Errors were detected in file 'C:\Users\yoshi\Documents\Test.xlsx'</summary>

<removedRecords>

<removedRecord>Removed Records: Formula from /xl/calcChain.xml part (Calculation properties)</removedRecord>

</removedRecords>

</recoveryLog>

I am afraid I cannot help you.

Good luck.