Getting SPecified Range is not large enough for incoming data field output error

I am writing the output to excel files using the parallel block until done (Crew Macros) as i have mutliple data elements to be written on different sheets.

on the last 2 outputs i am getting this error : SPecified range is not large enough for incoming data fields. never seen that error before and not sure why its coming. the data where i am getting this error has like 43 rows and 10 columns .

Any suggestions will be helpful

Thanks

Developer

Developer Tools

Accepted answers

mmenth

Have you tried the solution that worked in this instance?

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Strange-output-data-error/td-p/299777

All comments

MarqueeCrew

Are you specifying in the output the range (e.g. A1:H10) for output? A picture of the output configuration (all options displayed) would be helpful. If in your user settings, you have the XML displayed, that would be helpful too for the output tool.

Cheers,

Mark

mmenth

Have you tried the solution that worked in this instance?

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Strange-output-data-error/td-p/299777

a similar way worked for. i updated the sheet names and it was able to output properly. still not sure why the original sheet names were not working (they were new sheets).

Thank you all for your inputs,

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335