In linking Excel data cells into Powerpoint, do they come over as
relative or absolute references and how do you change from one to the
other?
Hi Steve,
Would you go for this?
In PowerPoint...
Insert > Object > Microsoft Excel Workbook
Switch to the source workbook
Edit > Copy
Switch to the workbook in the Presentation
Edit > Paste Special > Paste Link
Hi Steve,
This thread refers to linking Excel data cells, not pictures.
So my conclusion is that it is possible to link data between an Excel
document and an Excel workbook that's embedded in a PowerPoint presentation.
Steve Rindsberg said:Which sorta comes around to my original theory: you can't link anything into
PowerPoint/Mac.
The nice thing about links is that if the source data changes, the linked data
in PPT (by default, you can change this) automatically updates too.
Embedded objects with links to other data get you part way there, it's true,
but it requires you to activate the embedded object, which then wakes up and
goes "Hey, I got links!"
We run into this all the time on the PC. People link data from Excel into the
datasheet in MSGraph thinking that the graph will automatically update when the
data changes in Excel.
It won't. Not until you doubleclick the MSGraph chart in PPT to wake it up.
Bummer.
--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Featured Presenter, PowerPoint Live 2004
October 10-13, San Diego, CA www.PowerPointLive.com
================================================
Hi Steve,
You're absolutely right. I tried several ways of getting linked data
into PPT, but nothing would let me link directly. Only via an embedded
object could I link to a range of cells.
Of course you could do the VBA thing we figured out in a different
thread to have the workbook data update automatically, but that is
awkward for most users.
nearly so,
I link eight separate Excel workbooks (orig created in Excel 97) to a
single Consolidated workbook (also E '97). I have worked with these in
Excel 02 on XP operating system. This could be the problem, but when I
switch back over to '97, the same thing is occurring.
Suddenly, several of my relative links have turned absolute. One set of
cells, pointing to one particular Workbook insists on converting whatever I
type into an absolute L in Windows/TEMP file. It for the most part preserves
the cell reference, however, on one it changed them all by 2, so that if it
pointed to tab and cell 02!D5 it suddenly converted itself to 03!D7. It
converted another string of links from relative to absolute but the directory
was correct in where I keep these files, not the TEMP file. No tab or cell
number changes in this situation. The remaining 6 Workbooks remained
relative.
I have tried deleting and "re-saving" files that are linked up, but to no
avail.
Last other problem, is that when I tried to update in Excel 02, it tells me
that so many files are missing, even ones whose formulas didn't switch from
relative to absolute.
THANK YOU in advance for any shred of knowledge in this department.,
preferrably the button to make this all right!!
-Bobbie
Yup!
"OnData Property
An OnData handler runs when data arrives from an application other than
Microsoft Excel. You can use the OnData property of the Worksheet,
Application, Link, or Subscriber object to associate a procedure with
the arrival of data linked to one of these objects through dynamic data
exchange (DDE) or through object linking and embedding. (In Microsoft
Excel for the Macintosh running under System 7, data can also arrive
through the Publish and Subscribe feature.)"
<http://support.microsoft.com/default.aspx?scid=/support/Excel/Content/Onevent/Onevent.asp>
That sounds about the time of Office 4.2.1
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.