Wouldn't it be just as easy to save as a new workbook then change the Chart
designs?


Gord Dibben MS Excel MVP

On Mon, 6 Oct 2008 09:18:06 -0700, TomP
wrote:

I have a workbook that has 12 worksheets and was wondering if there is a way
I could create a link of the entire workbook to a different excel file
without having to recreate formulas...etc.

What I want to do is to change the design of the graphs and still show the
numbers and/or stats.

Thank you,

Tom