Now, stay with this one, it splits into two thoughts now.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).When opening a presentation, Power Point will ask if you wish to update the links. The Links window will open, which provides you with various options to update, edit and break links.If you link Excel files to Power Point presentations often, you will soon find it doesn’t always behave how you might expect.
In addition to the data, some cells to the left and on top are reserved for category and series labels.If Power Point is not yet running, it starts automatically.In Power Point, when the mouse pointer is on a slide, the familiar insertion rectangle appears.But that’s just not how it works unfortunately, you still have to update each link individually. Below you will find VBA code for Power Point and for Excel.Yes, that’s right, you can update the links to a Power Point document from within Excel. In a previous post we considered how to link Excel files to Power Point presentations.