Two completely unrelated workbood. Why is it asking me about updatinglinks?
I have a workbook, one sheet, one named range: “dist_date”
Here is my code for the simplest of graph
Set Cht_dist555 = Charts.Add
With Cht_dist555
.ChartType = xlColumnStacked
.SetSourceData Source:=Range("dist_data"), PlotBy:=xlColumns
.Deselect
End With
When I save and reopen, it asks me about updating links. I delete the
chart, save and reopen: the update link message is gone.
I made no reference in my workbook whatsoever about the other workbook
including in the VBA reference.
So I changed the updatelinks to xlupdatelinksnever under the
"thisworkbook" property and it works.
What really bugs me is not understanding how this stupid little code
to create a chart links to another workbook.
Thoughts?
|