Vicky,
Now there goes Steve again. In spite of us being very good friends,
the only thing two things we agree about are:
1. We hardly ever agree on anything other than #2
2. Steve's wife is a lovely beautiful really nice person.
Glen covered linking which I gave up years ago since it can be very
fragile. It can be managed if you really know what you are doing and
who knows that? Certainly not me. Now there are three things Steve and
I agree on!
I almost always use Insert Object since I want the data to go along
with the chart. But I ALWAYS copy the chart sheet and data worksheet
from Excel to a new workbook, save it and use Insert object, then
delete the intermediate workbook for housekeeping since it is now in
PPT and fully editable there.
Jon Peltier, an Excel MVP, who also works in PPT prefers to copy the
chart in Excel as a Picture, (Shift + Edit + Copy as Picture) and then
pastes into PPT and the chart is fine but there is no data associated
with it since it is now a picture. I have used this quite successfully
when I do not want to release real editable data (think Wall St SEC
requirements).
Just be cautious when taking advice from Steve relating to Excel. Now
there are four things he and I can agree on. (vbg)
Brian Reilly, MVP
