I think I've got it to work ok now.I'm just making a copy of the entire worksheet into another workbook,then renaming it and then using the ActiveWorkbook.BreakLink method togenerate the required values, leaving the formatting untouched.