Table Cell Formulas

J

James

After creating a table in Power Point, and populating some of the cells with
numerical data....can I sum the values of the cells like you can in Excel
with the "=SUM(c1..." formula?

Thx,

James
 
E

Echo S

James said:
After creating a table in Power Point, and populating some of the
cells with numerical data....can I sum the values of the cells like
you can in Excel with the "=SUM(c1..." formula?
Click to expand...

PPT tables don't do formulas.

You could do your table in Excel and import it into PPT in a variety of
ways.
 
J

James

OK, thanks. If I have the formulas built in Excel, will they continue to
work in PowerPoint if I change an values, or will have to make the changes in
Excel and re-import?
 
E

Echo S

Steve said:
If you link or embed from Excel to PowerPoint, you'll be able to
doubleclick the spreadsheet in PPT. That will launch Excel either
in-place or standalone and you'll be able to edit the formulae and
data.
Click to expand...

<smacking forehead>
Duh! What was I thinking?
 
J

James

Thanks for the info. I typically would prefer to not have to worry about
having the linked Excel file in a certain place as I will be emailing it out
to recipients that will not have the same network accesses I have.
 
E

Echo S

Steve Rindsberg said:
Worth testing before trusting, but it SHOULD work with linked XLS files as long
as the XLS and the PPT land in the same folder.

But you can embed instead and everything they need is right there in the PPT
file. Let's modify that: everything in the whole XLS is right there in the PPT
file, so if you don't want them to have access, you'll want to copy to another
XLS then embed from there.
Click to expand...

And James, to embed the XLS file, you'd copy your data in Excel and then in
PPT use Edit/Paste Special and choose Excel Workbook Object. Mind you, that
embeds the entire worksheet, as Steve was explaining.

You could get the same result using plain ol' paste in most versions of PPT.
But to be on the safe side, use Edit/Paste Special.

Oh, you could *also* use Insert/Object/Create from File and insert the Excel
file thataway. Lots of ways to get to the same place. (Where did you say you
want to go today? <g>)
Click to expand...
 

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

Similar Threads

Excel - Wich Function should I use? 1
Would like to input 3 letters into a cell, each having a different numerical value 5
Multiple IF Statement in Word 5
Copy addition formula of non-consecutive horizontal cells 2
formula for arriving net difference 0
If, Or, and 5
Cell data entering slow! 0
Conditional Formatting with VBA 4

Top