Why can't I see links in the Edit menu for Powerpoint

[Guest]

I have paste-linked some data from an Excel sheet into the datasheet of a
graph on a Powerpoint page. I would like to do two things in Powerpoint:

open the link
edit the link so that the source data becomes the same data range in another
file

However the Links option on the Edit menu is greyed out.

What should I do?

Thanks

Stephen Connell

 

[Steve Rindsberg]

I have paste-linked some data from an Excel sheet into the datasheet of a
graph on a Powerpoint page. I would like to do two things in Powerpoint:

open the link
edit the link so that the source data becomes the same data range in another
file

You can't do either directly.

You'd have to open the source file and relink data to your MSGraph datasheet.

 

[Guest]

Steve

Thanks for your answer. Do you know why this state of affairs exists? If I
had created the chart in Excel and pasted it into Powerpoint I wouldn't have
had any problems. But is seems that the greater choice of charts styles and
formats in Powerpoint comes at a price. Pretty odd for a programme that has
been through several incarnations.

Stephen

 

[Steve Rindsberg]

Thanks for your answer. Do you know why this state of affairs exists?

I think probably MSGraph has always been seen as a "little brother" to Excel.
Or maybe "poor relation" says it better.

If I
had created the chart in Excel and pasted it into Powerpoint I wouldn't have
had any problems. But is seems that the greater choice of charts styles and
formats in Powerpoint comes at a price. Pretty odd for a programme that has
been through several incarnations.

I don't really do that much with Excel directly, but I've done a fair bit of VBA
prodding at both its charts and MSGraph's charts. It always struck me that MSGraph
offers pretty much the same styles/formats as Excel but fewer options in some other
areas.

I'm interested to know what you're seeing that I'm not.