I use the Render tool daily to generate Excel reports with multiple worksheets.The page layout/format is global. Many of my report include 30+ columns of data in multiple tabs, along with a summary tab, with fewer columns.
When formatting the page size, if I don't set "Custom" and some very large number (30-50), Alteryx randomly truncates the headings and any text in the data. If set the page size to such a large number, the "summary" Excel tab (which may only contain 5 columns) is set to the same page format as the larger worksheets. I actually have end-users complain that they have to resize the summary page. A "page format by worksheet" would allow a landscape orientation, with a page size of 8 1/2 X 11 for the "summary" worksheet, and "custom" for the others.
The version of Excel in the "Temp Excel Output" is still 2007. Can we get this updated?