View Full Version : How to sum figures in a Powerpoint 2003 table?


M baiomy
10-12-2006, 09:20 AM
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.

Luc
10-12-2006, 09:49 AM
M baiomy,
No such thing in PPT. Maybe try paste/linking a Word/Excel table.

--
Luc Sanders
(MVP - PowerPoint)


"M baiomy" <M baiomy@discussions.microsoft.com> schreef in bericht
news:AD48728C-334D-44EE-BBCA-A8B6C03E2D30@microsoft.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.

Bill Foley
10-12-2006, 01:05 PM
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

--
Bill Foley
Microsoft PowerPoint MVP
Microsoft Office Specialist Master Instructor
www.pttinc.com
"M baiomy" <M baiomy@discussions.microsoft.com> wrote in message
news:AD48728C-334D-44EE-BBCA-A8B6C03E2D30@microsoft.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.

M baiomy
10-16-2006, 09:06 AM
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.

"Bill Foley" wrote:

> 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
>
> --
> Bill Foley
> Microsoft PowerPoint MVP
> Microsoft Office Specialist Master Instructor
> www.pttinc.com
> "M baiomy" <M baiomy@discussions.microsoft.com> wrote in message
> news:AD48728C-334D-44EE-BBCA-A8B6C03E2D30@microsoft.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.
>
>
>

Bill Foley
10-16-2006, 04:20 PM
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.

--
Bill Foley
Microsoft PowerPoint MVP
Microsoft Office Specialist Master Instructor
www.pttinc.com
"M baiomy" <Mbaiomy@discussions.microsoft.com> wrote in message
news:31CFC130-49B4-40E9-8768-A31C7311CFF7@microsoft.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
> calulate. i think there should be another way to calulate a huge number of
> raws .. don't you agree !
>
> Appreciate your support.
>
> Regards.
>
> "Bill Foley" wrote:
>
>> 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
>>
>> --
>> Bill Foley
>> Microsoft PowerPoint MVP
>> Microsoft Office Specialist Master Instructor
>> www.pttinc.com
>> "M baiomy" <M baiomy@discussions.microsoft.com> wrote in message
>> news:AD48728C-334D-44EE-BBCA-A8B6C03E2D30@microsoft.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.
>>
>>
>>

Steve Rindsberg
10-16-2006, 05:43 PM
In article <31CFC130-49B4-40E9-8768-A31C7311CFF7@microsoft.com>, M baiomy wrote:
> 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.
>
> Regards.
>
> "Bill Foley" wrote:
>
> > 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
> >
> > --
> > Bill Foley
> > Microsoft PowerPoint MVP
> > Microsoft Office Specialist Master Instructor
> > www.pttinc.com
> > "M baiomy" <M baiomy@discussions.microsoft.com> wrote in message
> > news:AD48728C-334D-44EE-BBCA-A8B6C03E2D30@microsoft.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.
> >
> >
> >
>

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