hm ... interesting idea; I'll give it a try. I DO have to span multiple modules, but I can use formal parameters and that might have the same effect since there will be no global declaration.

I've found a workaround which is to close the file under a different name. For some reason, that allows excel to close and then I can kill the file that just has the data and rename the file that has both the data and the charts.