Does anyone know if there is a tool in ALTERYX that can read MS Excel worksheet cells that have a "Used Range" with "Special Cells with Cell Type Formulas" and return its content as a string? I am trying to document a very large and complex MS EXCEL workbook and VBA code for that works only on the small ranges. When I attempt read formulas from a worksheet with 1000+ rows and 10 + columns there seems to be not enough memory to hold huge arrays values and VBA program "hangs"... I hope there is a solution in Alteryx for what I am trying to do, is there? Any suggestions would be greatly appreciated!
