Getting error message when trying to Output Multiple Tabs to One Excel using render tool

[vrajgopal]

I have created a workflow and trying to save the output as multiple tab in same excel and getting the below error message

“We found a problem with some content in APAC SA report. Do you want us to recover.”

Any advice on how to solve this issue.

Attaching my workflow and raw data for reference.

[afv2688]

Hello @vrajgopal,

The problem is your raw sheet. You are trying to put a lot of columns together in a very tiny space.

Try adding the sheet into a different document (or taking it away).

It should solve the problem.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

[vrajgopal]

Sorry did not get your answer.

When i use Output tool i am able to save the raw data in excel format.

Its when i am trying to combine all 3 outputs in one spreadsheet I am not able to. My requirement is to have all 3 as a tab in same spreadsheet. Is there a way to do it.

[afv2688 · Accepted solution]

Hello @vrajgopal,

This should do it. I deleted the first formulas and replace tools. You can add them again. I just didn't had the files.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

[vrajgopal]

Thank you. It worked perfectly. 

The time taken to run the report will all data was very high. Will look at the performance angel.

Thank you.