Link PowerPoint with Excel Office for Mac 2008

[ringeroo]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I have data in Excel that I use to create charts in Powerpoint. I would like the Powerpoint file to automatically update as I update the information in Excel. I've followed the advice here:
http://www.agentjim.com/MVP/linkgraph.htm

However, this seems to constantly crash my Excel sheet. Further, the graphs are not nearly as "pretty" as they are when created in Excel and then pasted in as an image.
Finally, I do not seem to be able to put in the "add in" as suggested in the above directions. Any help you can provide would be greatly appreciated.

 

[Steve Rindsberg]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel I have data in Excel that I use to create charts in
Powerpoint. I would like the Powerpoint file to automatically update
as I update the information in Excel. I've followed the advice here:
http://www.agentjim.com/MVP/linkgraph.htm

The page begins with:

"These instructions were designed for users of Macintosh versions of
Microsoft Office, excluding Office 2008."

One of the reasons for excluding 2008 is that it doesn't support Visual
Basic for Applications (VBA, the language that most Office macros are
written in) as previous versions did and as future versions allegedly
will.

That's why you can't install the add-in (which is written in VBA).

 

[ringeroo]

Aaahhhhh, thanks for the answer Steve. Do you know of anywhere that has better instructions than for syncing 2008 Powerpoint with Excel?

 

[Steve Rindsberg]

Aaahhhhh, thanks for the answer Steve. Do you know of anywhere that
has better instructions than for syncing 2008 Powerpoint with Excel?

With luck, one of the regulars will pop in with an answer to that one.
I can't help much because I don't have 2008 (and am mostly a Windows
PPT sorta critter)

 

[CyberTaz]

Basically, Jim's procedure works for Office 2008. There are some
considerations, however, and the result will not update automatically in the
presentation file. Those differences are more 'after-the-fact' pertaining to
the updating rather than to the creating of the link. Also, the updating has
to be done manually & as Steve indicated the add-in is useless because of
having no VBA in Office 2008. Whether something comparable could be
constructed with Apple Script I don't know.

If you're experiencing crashes it suggests that your installation of 2008 is
lacking updates. I don't know that to be the case since you haven't
indicated your current update levels, but what you described is something
that was addressed several updates ago. In all honesty I'm working with
Tiger [10.4.11] at the moment & haven't tried this in Snow Leopard but I
don't think that should make any difference. Confirm that you're fully
updated to Office 12.2.3 & that OS X is at 10.6.2, then repair disk
permissions & see if that resolves the problem.

If not, please provide a more detailed description of the nature & volume of
the data being plotted, exactly what action is triggering the crash plus any
additional details that might be contributing to the issue. It's entirely
possible that some external factor is the cause rather than the link itself.

HTH |:>)
Bob Jones
[MVP] Office:Mac