• I could be wrong here but writing a macro to generate EXCEL for each value from the pick list should solve your problem.