I was asked by a client @brianvigus to help him put the current date onto a daily Excel output file. When they tried to prepend/append the date, it only would do so to the worksheet name and not to the workbook name. I do like the ability to update the table (worksheet) name and understand their desire to update the workbook name too.
My solution was to create a COMPLETE PATH\FILENAME|SHEETNAME data element and use the existing option to change the entire file path. That works.
I don't know if the solution to this idea is to update the help instructions to explain that table renames act differently than file renames or if the solution requires more functional options on append/prepend.