Welcome to Windows Help!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Updating Excel Link in PPT

 
   Windows Help (Home) -> Microsoft Powerpoint RSS
Next:  Convert online swf to 3GP for cell phone  
Author Message
jc

External


Since: Dec 4, 2008
Posts: 3



(Msg. 1) Posted: Wed Jan 20, 2010 7:51 pm
Post subject: Updating Excel Link in PPT
Archived from groups: microsoft>public>powerpoint (more info?)

Hey,
I've got a PPT presentation that has Excel files linked into thre
presentation (paste special; past link) but PPT isn't asking me to update
links when i open it....so therefore my PPT has old Excel data...how do i get
PPT to "refresh" and get the updated Data from Excel?

Thanks!!
JC

 >> Stay informed about: Updating Excel Link in PPT 
Back to top
Login to vote
Glen Millar

External


Since: Dec 4, 2008
Posts: 7



(Msg. 2) Posted: Thu Jan 21, 2010 7:25 am
Post subject: Re: Updating Excel Link in PPT
Archived from groups: per prev. post (more info?)

Hi,

What version? I think it 2003 and earlier it was Edit menu| Links?

It works for me here in 2007.

 >> Stay informed about: Updating Excel Link in PPT 
Back to top
Login to vote
jc

External


Since: Dec 4, 2008
Posts: 3



(Msg. 3) Posted: Thu Jan 21, 2010 9:01 am
Post subject: Re: Updating Excel Link in PPT
Archived from groups: per prev. post (more info?)

Glen,
thanks for the reply...i'm in PPT 2007. I have the Excel links set up
already...PPT just isn't asking me when I open the file to "update
links"...so my links don't refresh.

Any help would be great!!!

"Glen Millar" wrote:

> Hi,
>
> What version? I think it 2003 and earlier it was Edit menu| Links?
>
> It works for me here in 2007.
>
> --
> Regards,
> Glen Millar
> Microsoft PPT MVP
>
> Tutorials and PowerPoint animations at
> the original [URL="http://www.pptworkbench.com"]www.pptworkbench.com[/URL]
> glen at pptworkbench dot com
>
>
> "JC" wrote in message
>
> > Hey,
> > I've got a PPT presentation that has Excel files linked into thre
> > presentation (paste special; past link) but PPT isn't asking me to update
> > links when i open it....so therefore my PPT has old Excel data...how do i
> > get
> > PPT to "refresh" and get the updated Data from Excel?
> >
> > Thanks!!
> > JC
>
 >> Stay informed about: Updating Excel Link in PPT 
Back to top
Login to vote
jc

External


Since: Dec 4, 2008
Posts: 3



(Msg. 4) Posted: Thu Jan 21, 2010 9:46 am
Post subject: Re: Updating Excel Link in PPT
Archived from groups: per prev. post (more info?)

Glen,
I'm using 2007...I've got the excel sheet linked, but the PPT file no longer
asks me if i want to "update" the links when i open it..

"Glen Millar" wrote:

> Hi,
>
> What version? I think it 2003 and earlier it was Edit menu| Links?
>
> It works for me here in 2007.
>
> --
> Regards,
> Glen Millar
> Microsoft PPT MVP
>
> Tutorials and PowerPoint animations at
> the original [URL="http://www.pptworkbench.com"]www.pptworkbench.com[/URL]
> glen at pptworkbench dot com
>
>
> "JC" wrote in message
>
> > Hey,
> > I've got a PPT presentation that has Excel files linked into thre
> > presentation (paste special; past link) but PPT isn't asking me to update
> > links when i open it....so therefore my PPT has old Excel data...how do i
> > get
> > PPT to "refresh" and get the updated Data from Excel?
> >
> > Thanks!!
> > JC
>
 >> Stay informed about: Updating Excel Link in PPT 
Back to top
Login to vote
Steve Rindsberg

External


Since: Nov 8, 2008
Posts: 108



(Msg. 5) Posted: Thu Jan 21, 2010 2:12 pm
Post subject: Re: Updating Excel Link in PPT
Archived from groups: per prev. post (more info?)

I think what Glen meant was to check Edit | Links and make sure that each link
is set to Automatic update (at the bottom of the dialog box) rather than Manual.

In article wrote in message
> >
> > > Hey,
> > > I've got a PPT presentation that has Excel files linked into thre
> > > presentation (paste special; past link) but PPT isn't asking me to update
> > > links when i open it....so therefore my PPT has old Excel data...how do i
> > > get
> > > PPT to "refresh" and get the updated Data from Excel?
> > >
> > > Thanks!!
> > > JC
> >


==============================
PPT Frequently Asked Questions
[URL="http://www.pptfaq.com/"]http://www.pptfaq.com/[/URL]

PPTools add-ins for PowerPoint
[URL="http://www.pptools.com/"]http://www.pptools.com/[/URL]
 >> Stay informed about: Updating Excel Link in PPT 
Back to top
Login to vote
patchfoo

External


Since: Jan 27, 2010
Posts: 1



(Msg. 6) Posted: Wed Jan 27, 2010 6:51 am
Post subject: Re: Updating Excel Link in PPT
Archived from groups: per prev. post (more info?)

On Jan 20, 10:51 pm, JC wrote:
> Hey,
> I've got a PPT presentation that has Excel files linked into thre
> presentation (paste special; past link) but PPT isn't asking me to update
> links when i open it....so therefore my PPT has old Excel data...how do i get
> PPT to "refresh" and get the updated Data from Excel?
>
> Thanks!!
> JC

Click the Office button --> Prepare --> Edit links to files.

From there you can either select all of them and go to "Automatic" at
the bottom or you can keep them Manual and just click on "Update Now"
if you only want to update them once in a while (that's how I leave
them).
 >> Stay informed about: Updating Excel Link in PPT 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Updating Text in several PPT presentations - I have several presentation which have the same text on several pages and then specialized text for the rest. I have problems with people change text in one and not carrying it through to the other presentations. Is there a way to create a "mas...

Problems when pasting as link in Powerpoint - Hi Everybody, Stumbled upon a rather curious little thing (bug?) when trying to pase a chart as a link ( so that when the info the chart is based on changes, the chart updates. This does not happen if i pase the chart in as a picture) As can be seen....

Trying to link Slide ID to a button in presentation - I am having trouble figuring out how to link a button that will appear on a page of my presentation so that when clicked, it will automatically go to a specific slide. Any advice? EggHeadCafe - Software Developer Portal of Choice BOOK REVIEW:..

vba excel to PPT: name excel shape into PPT template with .. - Hi, I've got a macro that copies a shape/chart created in excel and then pastes the shape into a powerpoint slide that already has a number of other shapes in it (a template PPT file). I've noticed that when the shape is pasted into the PPT slide, PP...

Excel linking a Table - Opening the linked table source: - how do I remove the extra link info (e.g. "Book1.xslx!Sheet!R1C1:R5C2" Updating the Source file name of a linked table in Powerpoint: - how do i get the full path of the file? thanks, Amrit
   Windows Help (Home) -> Microsoft Powerpoint All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]