Embedded Excel graph's explosion

W

wlotto

I embedded a graph in an Excel worksheet onto a PPT slide.

(in PPT) Right-click>worksheet object>open (in Excel, I
do some editing.) File>close & return to xxx. (go back to
PPT.)

Q1: The embedded graph gets so big when I come back to
PPT! Why is it? Am I doing anything wrong?

Q2: Even if I paste-specialed the graph from an Excel
worksheet, it is recreated in a chartsheet when I open
it. Why?

thanks
 
J

John Langhans [MSFT]

[CRITICAL UPDATE - Anyone using Office 2003 should install the critical
update as soon as possible. From PowerPoint, choose "Help -> Check for
Updates".]

Hello,

To me, this sounds like a problem/limitation with how Excel creates the
rendering for its OLE objects when updated.

One of the first steps for troubleshooting OLE objects is to isolate
whether the problem is in the container (in this case, PowerPoint) or in
the server (in this case Excel).

To isolate the problem:
1) First try a different container applications. I usually recommend
WordPad since it's the most generic OLE container and it ships with Windows.
a) Insert same object into WordPad
b) If applicable, perform same operation on object (if possible) that you
performed in other container (such as resizing object)
c) Does the problem occur in both containers? - If so, the problem might
be with the source application or just an OLE limitation

2) Try different source applications: Which ones I recommend would depend
on the problem. However, it is not always possible to find another source
application which provides a rendering of it's object in the same way so
you might not be able to definitively determine whether it's a container
application problem (because it occurs with multiple source applications).
a) Insert different source object into the same container application (in
this case, PowerPoint)
b) If applicable, perform the same operation on this object that you
performed on the other object (such as resizing object)
c) Does the problem occur with this object? If not, repeat steps 2a-2c
with additional source applications.

So:
* If the problem occurs with only 1 source and multiple containers -> Most
likely a problem or limitation with source application
* If the problem occurs with only 1 container and multiple sources -> Most
likely a problem or limitation with container application
* If the problem occurs with multiple container and multiple sources ->
Most likely a limitation of OLE technology

As always, if you (or anyone else reading this message) have suggestions
about how PowerPoint and Office interoperability (such as Object Linking
and Embedding) should be improved, don't forget to send your feedback (in
YOUR OWN WORDS, please) to Microsoft at:

http://register.microsoft.com/mswish/suggestion.asp

As with all product suggestions, it's important that you not just state
your wish but also WHY it is important to you that your product suggestion
be implemented by Microsoft. Microsoft receives thousands of product
suggestions every day and we read each one but, in any given product
development cycle, there are only sufficient resources to address the ones
that are most important to our customers so take the extra time to state
your case as clearly and completely as possible.

IMPORTANT: Each submission should be a single suggestion (not a list of
suggestions).

John Langhans
Microsoft Corporation
Supportability Program Manager
Microsoft Office PowerPoint for Windows
Microsoft Office Picture Manager for Windows

For FAQ's, highlights and top issues, visit the Microsoft PowerPoint
support center at: http://support.microsoft.com/default.aspx?pr=ppt
Search the Microsoft Knowledge Base at:
http://support.microsoft.com/default.aspx?pr=kbhowto

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top