This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have an Alteryx workflow that outputs multiple data stream/tables (around 40+) to around 20 worksheets of an pre-defined macro enables excel file. However, when I run them, it gives me an unexpected error of "Error: Encountered existing data beyond the specified range" although the specified data range is quite well off. I do not get this error when I simply output them in a new excel file.
Also, sometimes Alteryx will not give any error, but the last row of data will not be populated in the output sheet. For instance, if there are 10 rows that Alteryx output is showing, only 9 rows will be outputted in my Macro enabled excel file.
Can someone please assist/guide me how should I approach this issue.
I am using the Named range in Excel. My outputs are going to the multiple sheets of an existing Macro enabled excel file, and some of these sheets have data coming from multiple output tools (of the same Alteryx workflow).
I am using the Overwrite Sheet (Drop) option.
The most surprising thing is that I do not get any of the above mentioned errors when I output them in a new excel file.
My output in Alteryx is less than the specified range. It is around 2 Rows and 4 columns (in this case).
The sheet name in Excel is exactly the same.Still, I get the error and that is why I am confused.
It is not that the named range does not work in my case. I am using around 40 named range outputs. However, only for 2-3 of the outputs it gives an error "Error: Encountered existing data beyond the specified range" even when the data is quite within the limit. Surprisingly, when I delete the sheet from my macro enabled excel file, it works. But, the next time I re-run the workflow it again fails and throws the error message. Since there are a lot of output sheets and the intent is to automate the process, deleting the sheets every time before executing the workflow is not going to work.