In my experience, the "Error: InboundNamedPipe GetOverlappedResult: The pipe has been ended" error is one of the non-descript errors that comes up in a number of situations when another, more specific error message isn't available.
The problem here circles around how that the Render tool and Output tool utilize Excel sheet names in file paths. Spoiler alert: the Render tool doesn't use sheet names in the file path, they have to be worked into the layout.
In this workflow, it looks like the [Type] field is intended to be your sheet names so let's build that into the Layout. The idea is that we're going to combine each sheet into one Layout record with vertical breaks. I added another Layout tool to group the sheets by Fullpath (so the field passes through), and set "Vertical with Section Breaks". In the case of Excel rendering, "Vertical Breaks" = "Sheets".
Check out the attached workflow and let me know if you have any questions.