Yes, there is one workbook per student, I'll have a look at using a macro. The chartsheet always has the same name so that sounds like a good way to go, you do get the occasional student with the graph document missing but it's not difficult to check for that before running it Thanks for the help