Edit links command

Bdavis · External Since: Sep 26, 2006 Posts: 5

I've got a PP 2007 presentation with a number of linked Excel Charts in it.
SOme of these links have gone bad . When I right-click and select "Edit
Data". I get an errorr that says:"The linked File is Not avaialble. Use the
Edit Links command to find the file"

Where is this command???? I must be blind but I can't find it anywhere.

John Wilson · External Since: Jul 08, 2006 Posts: 2002

Its in the office button > prepare> and then (scroll down) right at the bottom.
--
Amazing PPT Hints, Tips and Tutorials-
http://www.PPTAlchemy.co.uk
http://www.technologytrish.co.uk/ppttipshome.html
email john AT technologytrish.co.uk

"Bdavis" wrote:

> I've got a PP 2007 presentation with a number of linked Excel Charts in it.
> SOme of these links have gone bad . When I right-click and select "Edit
> Data". I get an errorr that says:"The linked File is Not avaialble. Use the
> Edit Links command to find the file"
>
> Where is this command???? I must be blind but I can't find it anywhere.

Rowan Sylvester-Bradley · External Since: May 17, 2011 Posts: 1

I have exactly the same problem. Where is this freaking command?

This is a perfect example of the madness of the ribbon design. Commands that experienced users have been using for years, or even decades for some of us, have suddenly disapeared and can't be found anywhere. Tasks which used to be easy now involve hours of tedious research using Google, posting messages on bulletin boards etc. Even more annoying, when you eventually find it, the same old command is there somewhere, just diguised and hidden. Is this what Microsoft intended when they introduced the ribbon?

It's all made worse by the serious deterioration of help facilities. In the olden days, you used to be able to search a local help file for topics mentioning a selection of words, see a list of topics, open them one by one until you find what you are looking for. Now, if I search Powerpoint help for Edit Links (a) I get a load of help for the whole of Office, most of which is irrelevant to me, (b) it goes off to the web somewhere to look for this data, so everything is so much slower, (c) there's no usable search facility. Either MS are intentionally trying to annoy their existing users, or they have no idea of the effect the changes they make to their software is going to have on users.

<rant mode off>

If you know how to edit links to external Excel files in Powerpoint 2007, please share this information...

Many thanks - Rowan

> On Monday, July 30, 2007 12:00 PM Bdavi wrote:

> I've got a PP 2007 presentation with a number of linked Excel Charts in it.
> SOme of these links have gone bad . When I right-click and select "Edit
> Data". I get an errorr that says:"The linked File is Not avaialble. Use the
> Edit Links command to find the file"
>
> Where is this command???? I must be blind but I can't find it anywhere.

>> On Monday, July 30, 2007 1:32 PM john AT technologytrish.co DOT uk wrote:

>> Its in the office button > prepare> and then (scroll down) right at the bottom.
>> --
>> Amazing PPT Hints, Tips and Tutorials-
>> http://www.PPTAlchemy.co.uk
>> http://www.technologytrish.co.uk/ppttipshome.html
>> email john AT technologytrish.co.uk
>>
>>
>> "Bdavis" wrote:

Jurgen Emanuels · External Since: Jul 21, 2011 Posts: 1

Hy Rowan,

I don't know if you have find a solution for your problem already. I manage to add a object in PPT.

Ribbon: Insert->Text->Object

Select create new.
From the Object type choose: Microsoft Office Excel Chart
Click OK.

This will add an excel char to your slide. You can edit it and change the data or even add another sheet to the excel object.

I hope this can solved your problem.

Regards,
Jurgen

> On Monday, July 30, 2007 12:00 PM Bdavi wrote:

> I've got a PP 2007 presentation with a number of linked Excel Charts in it.
> SOme of these links have gone bad . When I right-click and select "Edit
> Data". I get an errorr that says:"The linked File is Not avaialble. Use the
> Edit Links command to find the file"
>
> Where is this command???? I must be blind but I can't find it anywhere.

>> On Monday, July 30, 2007 1:32 PM john AT technologytrish.co DOT uk wrote:

>> Its in the office button > prepare> and then (scroll down) right at the bottom.
>> --
>> Amazing PPT Hints, Tips and Tutorials-
>> http://www.PPTAlchemy.co.uk
>> http://www.technologytrish.co.uk/ppttipshome.html
>> email john AT technologytrish.co.uk
>>
>>
>> "Bdavis" wrote:

>>> On Tuesday, May 17, 2011 8:49 AM Rowan Sylvester-Bradley wrote:

>>> I have exactly the same problem. Where is this freaking command?
>>>
>>>
>>>
>>> This is a perfect example of the madness of the ribbon design. Commands that experienced users have been using for years, or even decades for some of us, have suddenly disapeared and can't be found anywhere. Tasks which used to be easy now involve hours of tedious research using Google, posting messages on bulletin boards etc. Even more annoying, when you eventually find it, the same old command is there somewhere, just diguised and hidden. Is this what Microsoft intended when they introduced the ribbon?
>>>
>>>
>>>
>>> It's all made worse by the serious deterioration of help facilities. In the olden days, you used to be able to search a local help file for topics mentioning a selection of words, see a list of topics, open them one by one until you find what you are looking for. Now, if I search Powerpoint help for Edit Links (a) I get a load of help for the whole of Office, most of which is irrelevant to me, (b) it goes off to the web somewhere to look for this data, so everything is so much slower, (c) there's no usable search facility. Either MS are intentionally trying to annoy their existing users, or they have no idea of the effect the changes they make to their software is going to have on users.
>>>
>>>
>>>
>>> <rant mode off>
>>>
>>>
>>>
>>> If you know how to edit links to external Excel files in Powerpoint 2007, please share this information...
>>>
>>>
>>>
>>> Many thanks - Rowan