question - i have a worksheet in my excel workbook that does not get modified by appsheet but that does pull data from appsheet modifiable sheets. It has tables with arrays in it ("{formula}"). My problem is that anytime i make a modification to the excel via appsheet the array part of the formula disappears (โformulaโ) and so for my report i have to go back in and reapply it to all the affected cells.
Does anyone know why this is happening or how i can get it to stop erasing my arrays? TIA
PS: I have found a workaround with some vba code to put the arrays back in but only works with formulas under 255characters.
LinkedIn
Twitter
