Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copy another file worksheet into shared workbood | Excel Discussion (Misc queries) | |||
A macro that will break a link to another workbood | Excel Programming | |||
Updateing a workbook from another workbood | Excel Programming | |||
Unrelated | Excel Discussion (Misc queries) | |||
Unrelated help | Excel Discussion (Misc queries) |