Paste excel as link in PPT2007

  • Thread starter Thread starter JR Hester
  • Start date Start date
J

JR Hester

A coworker asked for some help on this one-- once excel data copied into
POwerPoint the data within the powerpoint cannot be edited. I tried my old
friend Paste special>as link and found that I can not edit the excel data
either. Has 2007 lost this capability? or am I just missing something here?

Thanks for your pointers
 
JR Hester said:
A coworker asked for some help on this one-- once excel data copied into
POwerPoint the data within the powerpoint cannot be edited. I tried my old
friend Paste special>as link and found that I can not edit the excel data
either. Has 2007 lost this capability? or am I just missing something
here?

Thanks for your pointers
Click to expand...


What happens when you try to edit the data?

As a matter of fact, how are you trying to access the data?
 
What happens when you try to edit the data? The slide show advances to next
slide

As a matter of fact, how are you trying to access the data? Click, Ctrl
Click, Alt Click, Shift Click

This may all stem from my my confusion over how I think it should react and
the way PowerPoint is designed to respond . I have tried at least 6 different
methods of creationg the "linked data".

What I just found furthers my confusion. The "link", when clicked on in
PowerPoints design mode, opens the file in Excel and does allow editing. This
edit is then displayed in the PoewerPoint slide when the Excel edit session
is closed.

What my co-worker and I expected is that we could edit the linked data from
the slideshow screen. This does NOT happen-- Click, Ctrl Click, Alt Click,
Shift Click all either advance a slide, back up a slide, or have no effect.
IS this the behaviour I should expect or is there a way, short of a
hyperlink, that will allow me to edit the linked file from the slideshow
mode? Or am I chasing a solution that does not exist?

Thanks for your response. Clarification appreciated.

This issue was presented to me as a difference in behaviour between Office
2002 and our new Office 2007. Unfortunately I no longer have an '02 version
to test against.



Echo S said:
JR Hester said:
A coworker asked for some help on this one-- once excel data copied into
POwerPoint the data within the powerpoint cannot be edited. I tried my old
friend Paste special>as link and found that I can not edit the excel data
either. Has 2007 lost this capability? or am I just missing something
here?

Thanks for your pointers
Click to expand...


What happens when you try to edit the data?

As a matter of fact, how are you trying to access the data?

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx

.
Click to expand...
 
Further investigation revealed one workstation with Office XP still
operational. Both versions seem to behave the same way-- the link can be
edited in design mode of PowerPoint but not in slideshow mode! Looks like I
was chasing that non existent solution after all.

Thanks again,

JR Hester said:
What happens when you try to edit the data? The slide show advances to next
slide

As a matter of fact, how are you trying to access the data? Click, Ctrl
Click, Alt Click, Shift Click

This may all stem from my my confusion over how I think it should react and
the way PowerPoint is designed to respond . I have tried at least 6 different
methods of creationg the "linked data".

What I just found furthers my confusion. The "link", when clicked on in
PowerPoints design mode, opens the file in Excel and does allow editing. This
edit is then displayed in the PoewerPoint slide when the Excel edit session
is closed.

What my co-worker and I expected is that we could edit the linked data from
the slideshow screen. This does NOT happen-- Click, Ctrl Click, Alt Click,
Shift Click all either advance a slide, back up a slide, or have no effect.
IS this the behaviour I should expect or is there a way, short of a
hyperlink, that will allow me to edit the linked file from the slideshow
mode? Or am I chasing a solution that does not exist?

Thanks for your response. Clarification appreciated.

This issue was presented to me as a difference in behaviour between Office
2002 and our new Office 2007. Unfortunately I no longer have an '02 version
to test against.



Echo S said:
JR Hester said:
A coworker asked for some help on this one-- once excel data copied into
POwerPoint the data within the powerpoint cannot be edited. I tried my old
friend Paste special>as link and found that I can not edit the excel data
either. Has 2007 lost this capability? or am I just missing something
here?

Thanks for your pointers
Click to expand...


What happens when you try to edit the data?

As a matter of fact, how are you trying to access the data?

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx

.
Click to expand...
Click to expand...
 
Editing data from slide show works the same in previous versions as in 2007,
so yes, I think the issue is confusion between Normal (editing) View and
Slide Show View.

To edit during a Slide Show, you need to add an object action animation. I
posted instrux for this recently; you can access them here:

http://groups.google.com/group/micr...st&q=object+action+animation#2281bc31405c79a9

Same link, just smaller: http://tinyurl.com/ykrr5ax

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx


JR Hester said:
What happens when you try to edit the data? The slide show advances to
next
slide

As a matter of fact, how are you trying to access the data? Click, Ctrl
Click, Alt Click, Shift Click

This may all stem from my my confusion over how I think it should react
and
the way PowerPoint is designed to respond . I have tried at least 6
different
methods of creationg the "linked data".

What I just found furthers my confusion. The "link", when clicked on in
PowerPoints design mode, opens the file in Excel and does allow editing.
This
edit is then displayed in the PoewerPoint slide when the Excel edit
session
is closed.

What my co-worker and I expected is that we could edit the linked data
from
the slideshow screen. This does NOT happen-- Click, Ctrl Click, Alt Click,
Shift Click all either advance a slide, back up a slide, or have no
effect.
IS this the behaviour I should expect or is there a way, short of a
hyperlink, that will allow me to edit the linked file from the slideshow
mode? Or am I chasing a solution that does not exist?

Thanks for your response. Clarification appreciated.

This issue was presented to me as a difference in behaviour between Office
2002 and our new Office 2007. Unfortunately I no longer have an '02
version
to test against.



Echo S said:
JR Hester said:
A coworker asked for some help on this one-- once excel data copied into
POwerPoint the data within the powerpoint cannot be edited. I tried my
old
friend Paste special>as link and found that I can not edit the excel
data
either. Has 2007 lost this capability? or am I just missing something
here?

Thanks for your pointers
Click to expand...


What happens when you try to edit the data?

As a matter of fact, how are you trying to access the data?

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx

.
Click to expand...
Click to expand...
 
Back
Top