Excel Link to PPT ?

  • Thread starter Thread starter Lisa
  • Start date Start date
L

Lisa

Hello:

I created my first excel source doc with the graphs
linking to a PPT report, 20 pages long. The problem that
my team is presenting is it takes 25 mins and longer to
open the ppt and refresh the excel links. Is there any
way to make the refresh work faster? HELP. Do I adjust
the excel doc somehow? The links were establshed using
paste special (link option). This was suppose to be a
solution to a problem, but now it's turning into a new
problem. Perhaps being new at this I've overlooked
something? Any advice, and alternatives, would be helpful
and very much appreciated.

Thanks,
Lisa
 
You are using the right general technique. It is not clear why it takes
25 minutes to update the PP file. Where are these files? On a network?
If so, what kind?

How big are the XL charts -- in terms of number of data points? If you
only open the XL file, how long does that take? How long does it take
to recalculate the file?

By and large, most of my XL-PP links are just that -- links. However,
there are occassions when performance demands require that I break the
link. In these few and infrequent cases, I use an image of some sorts.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Business solutions leveraging technology
Microsoft Most Valuable Professional (MVP) 2000-2004
 
Hi:

Thank you for the response. I am able to open the excel
doc. within seconds. Both the Excel and PPT are located
on a shared LAN. The excel is 279KB and the PPT is
783KB. I refreshed every single link this morning. saved
the PPT with the refreshed links, then went to launch the
PPT and hit the accept to refresh the links to see what it
would do and it clocked me 45 mins, then I had close using
Task Manager. It never refreshed. HELP!!!! Does anyone
know what happened, or an alternative????

Thanks again,
Lisa
 
What I do in this case is set up a routine that copies the charts from
Excel one by one as pictures, and pastes them into the appropriate
slides. It's not dynamic, but a macro runs very fast.

45 minutes seems like an awfully long time, but I try to avoid working
across a LAN.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
As I'm new at this, would you be able to help me learn how
to set up a "routine that copies the charts from excel to
PPT?"

Thank you for presenting an alternative for me. The
reason for using the LAN is people have to update this
document are in different cities throughout the U.S.

Thanks again!
Lisa
 
Lisa -

Unmunge my email address and send me a note. This is a bit larger than a
usual newsgroup posting.

The basics are in a page on my web site:

http://peltiertech.com/Excel/XL_PPT.html

Then it's a matter of recordkeeping to make sure the proper chart gets
onto the proper slide.

BTW, doesn't the "L" in LAN stand for Local?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top