Entire data not coming in Excel output file

Question

Hi ,

I'm facing a weird issue. My Alteryx workflow creating all the outputs with all the records but the moment this is going into excel sheet, some records are getting dropped. And this is not happening in all the tabs ,just in few tabs.

I'm just using the same excel sheet and overwriting everytime.

When i'm opening my excel output ,the below message appears.

After that i get below error message.

And then finally file opens in Repaired mode with very less data in it.

Most of the records are dropped.

Can someone help in this? How to fix this?

MichelleL · Answer

Hi @Pandey19  - can you share a few rows of data that Excel rejects?  I'm guessing perhaps there is something in the data that Excel  does not like???  Actually it would be helpful to see a few rows that it does accept as well for comparison purposes.

Pandey19 · Answer

@Luke_C

Well there is no fixed records. Today i have 100, tomorrow it can be in thousands.

Below is my output configuration.

For some tabs i've to overwrite data in different ranges. In some tab its a straight dump of data.

Luke_C · Answer

How many records total are you expecting? Can you share the output tool configuration?