Thanks MarvinP. I will review the info you posted, but I think it requires intervention by someone. I am trying to develop a workbook that someone needs not do anything other than import data downloaded from a corporate system and the workbook does all the rest. I have a workaround however it is not very efficient.