1 - It is best to put the charts on their own chart sheet.
Better if you create custom size chart pages in Excel so you don't have to resize the devils in PPT. worksheets is that the size information seems to be somehow embedded in the upper left hand corner of the chart.
a) if the "upper left hand corner of the chart is not visible" in what would be the Active Window of the spreadsheet (if it were open), the update linker won't see it and may not update the chart, or worse, may chop off part off the chart image. b) the second issue is the Active Window zoom factor, if you are really going to insist on putting charts on worksheets (more on that later).
I have done a little googling and am coming up with 50 solutions. The big gotcha here is that both of these files will be in one folder in a document library in a sharepoint site.
The other gotcha, which is kind of a given, is that I want the ppt to update to latest excel data when it is opened.
On the plus side: since all the charts are embedded, you don't have to worry about links to external files breaking or put up with MS' silly warning messages and slow updates to links every time you open the file.
AKA: Everything You Were Afraid To Ask Brian Reilly About Excel Charts, But That's OK, 'Cause He's Gonna Tell You Anyway.
Contents © 1995 - 2018 Stephen Rindsberg, Rindsberg Photography, Inc. You may link to this page but any form of unauthorized reproduction of this page's contents is expressly forbidden.