Chart Links ?

  • Thread starter Thread starter kevin carter
  • Start date Start date
K

kevin carter

We have a workbook ('Book1') that we need to archive every week.
In this workbook there are 3 charts (on a tab called 'graphs') which have
source data linked to a tab called 'data' all within the same workbook.
When we 'SaveAs' to a different location the source code of the charts is
remaining with the original workbook ('Book1') and not with the newly saved
workbook ('Book2').

Why is this happening, and how do we fix it????

Kevin
 
Kevin,

This doesn't sound like normal Excel behaviour...

What you've described should only happen if you copy
the 'charts' worksheet on its own into a new workbook and
then save it. I can't think of any options that would
alter this...

What does the series formula for each of the original
charts in Book1 look like. How does this compare to the
series formula for the same chart in Book2? (the series
formula appears in the formula bar when you select a chart
series).

Cheers,
Dave
(at Dunton!)
 
Thanks for reply
This is what is happening
Book1 has this as the source data
Name = data!$I$26
Values = data!$I$27:$I$38

when it is saved (book2) it becomes

Name = 'D:\Documents\[Book1.xls]data'!$I$26
Values =
'D:\Documents\[Book1.xls]data'!$I$27:$I$38
any ideas?
 
Back
Top