You made the statement: "The solution to this is to create the worksheets in the same order as in the template file and to +specify the links in the same order using the store_formula() calls suggested by chartex. In addit +ion you should omit any formulas in the template file and create the charts in the order that you +want them in the target file." I tried this. I created the worksheets in the exact order that I would use them. I did drag the tab +s around, after I was finished, to make it look like what I think it should look like. It still do +esn't work. You also said: However, if you omit one of these links or worksheets in the workbook then one or more of the chart +s will end up with a reference to a worksheet that doesn't exist or to the wrong worksheet. And th +is will cause Excel to crash (or at best load in repair mode). Does this mean that I have to have all the worksheets and chartsheets everytime I create a workbook +?