LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy another file worksheet into shared workbood apermes Excel Discussion (Misc queries) 1 March 14th 10 11:21 PM
A macro that will break a link to another workbood Michael Lanier Excel Programming 2 June 29th 09 03:30 PM
Updateing a workbook from another workbood Robert[_32_] Excel Programming 1 March 29th 07 03:20 AM
Unrelated capnsean Excel Discussion (Misc queries) 2 June 22nd 06 08:37 PM
Unrelated help Rob Excel Discussion (Misc queries) 3 September 22nd 05 02:12 PM


All times are GMT +1. The time now is 02:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"