PC Review


Reply
Thread Tools Rate Thread

Changing linked workbook area in Powerpoint

 
 
=?Utf-8?B?Sk0gV2hlZWxlcg==?=
Guest
Posts: n/a
 
      16th Jun 2005
I have a number of Excel workbook links set-up in a Powerpoint file. When I
update the links, some parts of the Excel workbook I want to show are being
cut-off. PP Help tells me that to fix the problem I need to double-click on
the workbook and then use the sizing marks to adjust the cells of the
worksheet pulled into PP. When I double-click the Excel program opens up and
I adjust the selected range in Excel, however, I am unable to get back into
PP (no check mark or x near the function key). I used to be able to perform
this feature. I think the problem may be that I am now using MS Office 2003
rather than 2000 and there is a glitch in the program. Previously, when I
double-clicked on the workbook, a small Excel workbook would open inside PP
and I did not have a problem making the changes. Any ideas? I have likely
have 50+ links with this issue and do not want to repaste special them all!
My coworkers have also had the same experience.
 
Reply With Quote
 
 
 
 
Steve Rindsberg
Guest
Posts: n/a
 
      17th Jun 2005
In article <4CEA5C88-84E5-4C05-A031-(E-Mail Removed)>, JM Wheeler
wrote:
> I have a number of Excel workbook links set-up in a Powerpoint file. When I
> update the links, some parts of the Excel workbook I want to show are being
> cut-off. PP Help tells me that to fix the problem I need to double-click on
> the workbook and then use the sizing marks to adjust the cells of the
> worksheet pulled into PP. When I double-click the Excel program opens up and
> I adjust the selected range in Excel, however, I am unable to get back into
> PP (no check mark or x near the function key). I used to be able to perform
> this feature. I think the problem may be that I am now using MS Office 2003
> rather than 2000 and there is a glitch in the program. Previously, when I
> double-clicked on the workbook, a small Excel workbook would open inside PP
> and I did not have a problem making the changes. Any ideas? I have likely
> have 50+ links with this issue and do not want to repaste special them all!
> My coworkers have also had the same experience.


You should be able simply to save the file in Excel then quit or switch back to
PPT (Alt+TAB)

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================


 
Reply With Quote
 
=?Utf-8?B?SldoZWVsZXI=?=
Guest
Posts: n/a
 
      23rd Jun 2005
Steve,
I tried this technique on a few different problems with no luck. I was able
to switch back into PP, but the linked area did not change. Any ideas?

"Steve Rindsberg" wrote:

> In article <4CEA5C88-84E5-4C05-A031-(E-Mail Removed)>, JM Wheeler
> wrote:
> > I have a number of Excel workbook links set-up in a Powerpoint file. When I
> > update the links, some parts of the Excel workbook I want to show are being
> > cut-off. PP Help tells me that to fix the problem I need to double-click on
> > the workbook and then use the sizing marks to adjust the cells of the
> > worksheet pulled into PP. When I double-click the Excel program opens up and
> > I adjust the selected range in Excel, however, I am unable to get back into
> > PP (no check mark or x near the function key). I used to be able to perform
> > this feature. I think the problem may be that I am now using MS Office 2003
> > rather than 2000 and there is a glitch in the program. Previously, when I
> > double-clicked on the workbook, a small Excel workbook would open inside PP
> > and I did not have a problem making the changes. Any ideas? I have likely
> > have 50+ links with this issue and do not want to repaste special them all!
> > My coworkers have also had the same experience.

>
> You should be able simply to save the file in Excel then quit or switch back to
> PPT (Alt+TAB)
>
> -----------------------------------------
> Steve Rindsberg, PPT MVP
> PPT FAQ: www.pptfaq.com
> PPTools: www.pptools.com
> ================================================
>
>
>

 
Reply With Quote
 
Steve Rindsberg
Guest
Posts: n/a
 
      23rd Jun 2005
In article <9C0F0D31-5BF2-402F-A869-(E-Mail Removed)>, JWheeler wrote:
> Steve,
> I tried this technique on a few different problems with no luck. I was able
> to switch back into PP, but the linked area did not change. Any ideas?


Hmm. Have a look here and see if any aHAs aHAppen:

Excel info cut off or cropped when pasted into PowerPoint
http://www.rdpslides.com/pptfaq/FAQ00068.htm

>
> "Steve Rindsberg" wrote:
>
> > In article <4CEA5C88-84E5-4C05-A031-(E-Mail Removed)>, JM Wheeler
> > wrote:
> > > I have a number of Excel workbook links set-up in a Powerpoint file. When I
> > > update the links, some parts of the Excel workbook I want to show are being
> > > cut-off. PP Help tells me that to fix the problem I need to double-click on
> > > the workbook and then use the sizing marks to adjust the cells of the
> > > worksheet pulled into PP. When I double-click the Excel program opens up and
> > > I adjust the selected range in Excel, however, I am unable to get back into
> > > PP (no check mark or x near the function key). I used to be able to perform
> > > this feature. I think the problem may be that I am now using MS Office 2003
> > > rather than 2000 and there is a glitch in the program. Previously, when I
> > > double-clicked on the workbook, a small Excel workbook would open inside PP
> > > and I did not have a problem making the changes. Any ideas? I have likely
> > > have 50+ links with this issue and do not want to repaste special them all!
> > > My coworkers have also had the same experience.

> >
> > You should be able simply to save the file in Excel then quit or switch back to
> > PPT (Alt+TAB)
> >
> > -----------------------------------------
> > Steve Rindsberg, PPT MVP
> > PPT FAQ: www.pptfaq.com
> > PPTools: www.pptools.com
> > ================================================
> >
> >
> >

>


-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================


 
Reply With Quote
 
=?Utf-8?B?SldoZWVsZXI=?=
Guest
Posts: n/a
 
      28th Jun 2005
Steve,
I believe this article addresses a different problem. ( I previously
experienced the issue they are addressing when copying a wide range of
cells). The problem I'm having deals with a changing the range of the cells
included in a PP link after the information has already been paste-specialed.
I spoke with one of my IT co-workers and he believes the problem may have
something to do with ActiveX control vs. OLE programming. It seems like the
mini-Excel workbook appears if I paste an object. If I were only pasting,
this might work, but since the data I am working with changes frequently, I
want to be able to link to Excel. I would love to be able to use this
feature. Thanks.

"Steve Rindsberg" wrote:

> In article <9C0F0D31-5BF2-402F-A869-(E-Mail Removed)>, JWheeler wrote:
> > Steve,
> > I tried this technique on a few different problems with no luck. I was able
> > to switch back into PP, but the linked area did not change. Any ideas?

>
> Hmm. Have a look here and see if any aHAs aHAppen:
>
> Excel info cut off or cropped when pasted into PowerPoint
> http://www.rdpslides.com/pptfaq/FAQ00068.htm
>
> >
> > "Steve Rindsberg" wrote:
> >
> > > In article <4CEA5C88-84E5-4C05-A031-(E-Mail Removed)>, JM Wheeler
> > > wrote:
> > > > I have a number of Excel workbook links set-up in a Powerpoint file. When I
> > > > update the links, some parts of the Excel workbook I want to show are being
> > > > cut-off. PP Help tells me that to fix the problem I need to double-click on
> > > > the workbook and then use the sizing marks to adjust the cells of the
> > > > worksheet pulled into PP. When I double-click the Excel program opens up and
> > > > I adjust the selected range in Excel, however, I am unable to get back into
> > > > PP (no check mark or x near the function key). I used to be able to perform
> > > > this feature. I think the problem may be that I am now using MS Office 2003
> > > > rather than 2000 and there is a glitch in the program. Previously, when I
> > > > double-clicked on the workbook, a small Excel workbook would open inside PP
> > > > and I did not have a problem making the changes. Any ideas? I have likely
> > > > have 50+ links with this issue and do not want to repaste special them all!
> > > > My coworkers have also had the same experience.
> > >
> > > You should be able simply to save the file in Excel then quit or switch back to
> > > PPT (Alt+TAB)
> > >
> > > -----------------------------------------
> > > Steve Rindsberg, PPT MVP
> > > PPT FAQ: www.pptfaq.com
> > > PPTools: www.pptools.com
> > > ================================================
> > >
> > >
> > >

> >

>
> -----------------------------------------
> Steve Rindsberg, PPT MVP
> PPT FAQ: www.pptfaq.com
> PPTools: www.pptools.com
> ================================================
>
>
>

 
Reply With Quote
 
Steve Rindsberg
Guest
Posts: n/a
 
      29th Jun 2005
You're right. If the range of cells is changing rather than the display getting cut
off, it IS different.

Can you walk us through the steps to repro this?

In article <F7CB98DD-8B9A-4FF5-8EFC-(E-Mail Removed)>, JWheeler wrote:
> Steve,
> I believe this article addresses a different problem. ( I previously
> experienced the issue they are addressing when copying a wide range of
> cells). The problem I'm having deals with a changing the range of the cells
> included in a PP link after the information has already been paste-specialed.
> I spoke with one of my IT co-workers and he believes the problem may have
> something to do with ActiveX control vs. OLE programming. It seems like the
> mini-Excel workbook appears if I paste an object. If I were only pasting,
> this might work, but since the data I am working with changes frequently, I
> want to be able to link to Excel. I would love to be able to use this
> feature. Thanks.
>
> "Steve Rindsberg" wrote:
>
> > In article <9C0F0D31-5BF2-402F-A869-(E-Mail Removed)>, JWheeler wrote:
> > > Steve,
> > > I tried this technique on a few different problems with no luck. I was able
> > > to switch back into PP, but the linked area did not change. Any ideas?

> >
> > Hmm. Have a look here and see if any aHAs aHAppen:
> >
> > Excel info cut off or cropped when pasted into PowerPoint
> > http://www.rdpslides.com/pptfaq/FAQ00068.htm
> >
> > >
> > > "Steve Rindsberg" wrote:
> > >
> > > > In article <4CEA5C88-84E5-4C05-A031-(E-Mail Removed)>, JM Wheeler
> > > > wrote:
> > > > > I have a number of Excel workbook links set-up in a Powerpoint file. When I
> > > > > update the links, some parts of the Excel workbook I want to show are being
> > > > > cut-off. PP Help tells me that to fix the problem I need to double-click on
> > > > > the workbook and then use the sizing marks to adjust the cells of the
> > > > > worksheet pulled into PP. When I double-click the Excel program opens up and
> > > > > I adjust the selected range in Excel, however, I am unable to get back into
> > > > > PP (no check mark or x near the function key). I used to be able to perform
> > > > > this feature. I think the problem may be that I am now using MS Office 2003
> > > > > rather than 2000 and there is a glitch in the program. Previously, when I
> > > > > double-clicked on the workbook, a small Excel workbook would open inside PP
> > > > > and I did not have a problem making the changes. Any ideas? I have likely
> > > > > have 50+ links with this issue and do not want to repaste special them all!
> > > > > My coworkers have also had the same experience.
> > > >
> > > > You should be able simply to save the file in Excel then quit or switch back to
> > > > PPT (Alt+TAB)
> > > >
> > > > -----------------------------------------
> > > > Steve Rindsberg, PPT MVP
> > > > PPT FAQ: www.pptfaq.com
> > > > PPTools: www.pptools.com
> > > > ================================================
> > > >
> > > >
> > > >
> > >

> >
> > -----------------------------------------
> > Steve Rindsberg, PPT MVP
> > PPT FAQ: www.pptfaq.com
> > PPTools: www.pptools.com
> > ================================================
> >
> >
> >

>


-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro - Set Print Area for Changing Data Area ksp Microsoft Excel Programming 6 16th Mar 2011 03:50 PM
pulling color from cell of workbook to another linked workbook =?Utf-8?B?U3Vuc2hpbmU=?= Microsoft Excel Misc 5 28th Sep 2007 12:42 PM
Linked table Manager; how can I automate changing of the linked ta =?Utf-8?B?QnJhZCBCbGFrZQ==?= Microsoft Access External Data 2 7th Jul 2006 02:31 PM
changing print area in an entire workbook =?Utf-8?B?bHNjaHVo?= Microsoft Excel Worksheet Functions 7 4th Aug 2005 02:52 PM
Changing paths of linked tables without Linked Table Manger Ilka Microsoft Access Database Table Design 0 30th Jul 2003 01:43 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:59 PM.