Hi,
I've got about 60 files all using the same (complex) Excel template.
I need to be able to pull data from specific cells and to be able to push data back into these cells. A simple workflow was able to pull all of the data without any issues. I'm able to push data back in too.
The issue arises with the formatting of cells once data is pushed back into the files. I'm using the latest version of Alteryx which enables me to write to specific cells in a sheet without losing the formatting of the sheet. However, the formatting of the cells to which I'm writing are still lost.
I'm not too concerned about the colours, etc. as I was able to apply this sort of formatting using Excel's conditional formatting. The problem is that the cells need to be 'formatted' with the correct cell protection and this isn't something I can use the conditional formatting to achieve.
Is there a way to write to specific cells and still have these cells marked as either protected or unprotected?
I've attached an example workflow and spreadsheet. Both of the blue cells should be unprotected and all other cells protected. Running the workflow causes these two cells to become protected.
