Copying/Linking Entire Workbook

  • Thread starter Thread starter TomP
  • Start date Start date
T

TomP

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
 
TomP,

You are trying to Copy the Charts into a new book basically? I would right
click on the Tab and Move or Copy>Choose your other book. This will recreate
the Chart in the new book, and keep the target data.
 
Wouldn't it be just as easy to save as a new workbook then change the Chart
designs?


Gord Dibben MS Excel MVP
 
Back
Top