How to sum figures in a Powerpoint 2003 table?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

M baiomy - 12 Oct 2006 09:20 GMT

Please your support, are there any features similar to these in Word 2003 to
calculate the figures in a table that exist in Powerpoint 2003?

Regards.

Reply to this Message

Luc - 12 Oct 2006 09:49 GMT

M baiomy,
No such thing in PPT. Maybe try paste/linking a Word/Excel table.

Signature

Luc Sanders
(MVP - PowerPoint)

> Please your support, are there any features similar to these in Word 2003
> to
> calculate the figures in a table that exist in Powerpoint 2003?
>
> Regards.

Reply to this Message

Bill Foley - 12 Oct 2006 13:05 GMT

Not within a table, but if you use text box controls from the Control
Toolbox, it can be done using VBA. I have an example on my FAQ page at:

http://www.pttinc.com/ppt_faq8.html

Signature

Bill Foley
Microsoft PowerPoint MVP
Microsoft Office Specialist Master Instructor
www.pttinc.com

> Please your support, are there any features similar to these in Word 2003
> to
> calculate the figures in a table that exist in Powerpoint 2003?
>
> Regards.

Reply to this Message

M baiomy - 16 Oct 2006 09:06 GMT

Thanks alot Bill, I have tried this way and found it useful, however this
will imperatively be helpful in simple calculations with few figures to
calulate. i think there should be another way to calulate a huge number of
raws .. don't you agree !

Appreciate your support.

Regards.

> Not within a table, but if you use text box controls from the Control
> Toolbox, it can be done using VBA. I have an example on my FAQ page at:
[quoted text clipped - 6 lines]
> >
> > Regards.

Reply to this Message

Bill Foley - 16 Oct 2006 16:20 GMT

I agree, but PowerPoint wasn't designed to do calculations, merely to show
data/information. You could always insert an Excel or Word Object on your
slide and do the calculations either on the spreadsheet or table, depending
on which object you insert.

Signature

Bill Foley
Microsoft PowerPoint MVP
Microsoft Office Specialist Master Instructor
www.pttinc.com

> Thanks alot Bill, I have tried this way and found it useful, however this
> will imperatively be helpful in simple calculations with few figures to
[quoted text clipped - 16 lines]
>> >
>> > Regards.

Reply to this Message

Steve Rindsberg - 16 Oct 2006 17:43 GMT

> Thanks alot Bill, I have tried this way and found it useful, however this
> will imperatively be helpful in simple calculations with few figures to
> calulate. i think there should be another way to calulate a huge number of
> raws .. don't you agree !

You can iterate through the cells of a table.

Each cell has a .Shape property that returns the rectangle shape that defines
the cell, and if the shape has text, you can retrieve that and do whatever you
want with it, including converting it to a number and doing math with it.

Does that sound like it'd meet your needs?

> Appreciate your support.
>
[quoted text clipped - 10 lines]
> > >
> > > Regards.

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

Reply to this Message