So the only way of having dynamic Sheet names in excel templates is by using PAGE nodes. The whole concept needs to be based on existing fireld value. Note that some characters are not allowed in Sheet names and may cause errors. Also remember that you cannot have 2 the same sheet names in Excel and the last thing to remember is that you will get as many sheets as many unique values are currently in the table you are "looping through" in <Page> node tag
For the sake of this exercise i did following:
Created in Qlik Script island table with required value(s) for my sheet names
Add required field as Page node in NPrinting template (this automaticaly changes sheet name!!)
Add a coresponding table so i can derive Year value (this is only in case you would have multiple sheets)
Hope this helps
cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.