Output Error "Attempted to write beyond Excel's maximum row (1048576)"

I have a workflow that has been working perfectly for a few weeks that contains 10 output tools, all writing to excel. Today, I went to run my workflow again and I received an error message on four of the output tools. Three of them say "Attempted to write beyond Excel's maximum column (XFD)" and the other says "Attempted to write beyond Excel's maximum row (1048576)". I have confirmed with a browse tool that my output only has 17 columns and there are only 161 rows per output file.

As far as I know there would be nothing that happened to this file that could have caused a change. I am the only one use utilizes this workflow.

I have tried to delete out the output tools with errors and add new ones and close and restart my Alteryx. I also can't change my file output type to anything except excel.

Has anyone ever encountered this error before?

Thanks so much!

Error Message

Accepted answers

kbrezski

I was able to find a solution. When I would configure an output tool to overwrite a tab in excel, but keep formatting, I have been using "A1:ZZZ999999" for a long time, to ensure the entire space I would be writing to keeps its formatting. It appears in the most recent version of Alteryx (2023.1.1.123) this causes the error listed above. When I changed my range to be "A1:ZZ99" the issue went away and I was able to write to excel like normal.

caltang

Just drop the number and leave AU. It’ll write automatically.

All comments

binu_acs

@kbrezski Did you try with a different input file?

Alayna

Hi - What are your output options set to in the output tools? Is it appending each time or only overwriting? You can also try the suggestions in this post

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Output-Data-Error-number-of-records-exceeds-the-Excel-maximum/td-p/312087

kbrezski

binu_acs

@kbrezski @Instead of using the fixed range if you add a count record tool and use that count to the range , that would make your workflow dynamic

Terabithian

I encountered the same issue.

Even if my output record is surely less than 1048567, but if I set the output range to be A1:ZZZ9999999, I will receive this error. This happens in 2023.2 version.

However, using the same approach, I did not receive the error message in Version 2022.3.1.486.

Don't know whether the output tool changes in versions?

J_Gonz

Hey Everyone,

I'm running into a similar issue now that I have the 2024 version. With the older version I had an output tool configured with: output.xlsx|||'Sheet1$A1:AU10000000' and it worked just fine.

Now, this workflow is breaking on a daily with: Attempted to write beyond Excel's maximum row (1048576). No records were written.

Any suggestions on how to fix this? Or maybe where I can look to figure out how to re-configure? Any help is deeply appreciated.

Thank You,

Jessica

caltang

Just drop the number and leave AU. It’ll write automatically.

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167