Can't append data to existing excel as table

[Bushra_Akhtar]

Hi Team,

I have successfully used the Output Data tool to append to append data to a excel spreadsheet using a small data set.  However when I tried to do this for a larger data set and to a excel file with many more tabs which have validation rules built in it does not work.  If I try appending to an existing sheet nothing happens and if I try on a new sheet the data will save to one cell but not as a table.

I am not sure if I need to change anything on the excel file itself in case that is the issue.

Has anyone come across this before or can anyone help?

Many Thanks

B

[TrevorS]

I believe so. You would need to make all of the validation rules through the table tool for all data.
Essentially, you would need to do all conditional formatting for the entire dataset through Alteryx at the same time, rather than format and append.