Output in same file from two models breaks pivot

[Kdeshmukh]

Hi , 

I am using two alteryx models, which give output in same excel file, in different sheets. These models are for yearly data, one is for 2019 and another for 2018.

The output (Excel) file also has pivots based on output from 2019 data (Model).

The pivots breaks (pasted values) whenever second model is ran and output sheets are created in it.

While opening the file i get an error " Error, multiple attempts to open the file"

Currently as a way out i am getting 2018 data in separate excel file and then moving those sheets in the final file.

If anyone can help that will be great!!!!

Thanks and Regards 

[Kdeshmukh]

Hi Kucsi,

Thanks a lot for your suggestions, i don't know how but now Excel is working fine.(Guess excel has its own way :P) 

So, basically i am able to run the Alteryx model and the Pivots are intact!!!

your suggestions : 1. To start with fresh Excel File and 2. To combine the models and get output through one model were of great help!!

You have saved me tons of time and frustration 🙂

Thanks once again!!

Regards,

Ketki 

[Kucsi]

Hi Ketki,

glad to hear it! 🙂 

Always happy to help.

Thanks,

Kucsi