Render tool is not allowing to create new tab in existing excel workbook

[videet]

I have created one sheet using reporting module but render tool is not allowing to add new tab in existing excel and output the data.

Any help will me very much appreciated.

[atcodedog05]

Hi @videet 

First thing is default(only) operation of Render tool is overwrite file. Hence you need to render and than output other tabs later.

Hope this helps 🙂

[videet]

@atcodedog05 ,

So there is no option to output data using render tool with new tab in existing workbook

Am i right?

First we need to render the progress further

[atcodedog05]

Hi @videet 

Yes, thats right there is no option to output data using render tool with new tab in existing workbook because render always overwrites file. And Yes, we need to render first then progress further.

Apparently its the limitation and way to go 😶 

[videet]

@atcodedog05 ,

Before render tool i have couple of output data how do i stop them now and execute after render tool?

[atcodedog05]

Hi @videet 

I am guessing this macro will help you. Which processes one after other.

https://www.youtube.com/watch?v=xbfIatkYO5Q

Hope this helps 🙂

[videet]

@atcodedog05 ,

I am not able to find crew macro as shown in video.

Only block until done i can find.

Can you please help

[atcodedog05]

Hi @videet 

Oh sorry my bad i thought it covered it. You can download & install the macros here http://downloads.chaosreignswithin.com/Macros.zip. then it will be visible in the palate.

If you dont want to install. Here is the copy of the macro which you can import.

Crew Macro download page : http://www.chaosreignswithin.com/p/macros.html 

Hope this helps 🙂