View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Frank[_28_] Frank[_28_] is offline
external usenet poster
 
Posts: 14
Default 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?