Table Cell Formulas

[Guest]

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

 

[Echo S]

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?

PPT tables don't do formulas.

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

 

[Guest]

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?

 

[Echo S]

You'd have to make the changes in Excel and re-import. Sorry.

 

[Steve Rindsberg]

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?

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.

Which is better, linking or embedding? That depends on how you intend to use
and distribute the presentations. If you need to know more, post a bit more
detail on your needs and we'll fill in some blanks.

 

[Echo S]

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.

<smacking forehead>
Duh! What was I thinking?

 

[Steve Rindsberg]

<smacking forehead>
Duh! What was I thinking?

You were preoccupied with underlined > and < symbols.
It's excusible. ;-)

 

[Guest]

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.

 

[Steve Rindsberg]

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.

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.

 

[Echo S]

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.

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>)

 

[Guest]

Great information. I really appreciate it.

James

 

[Echo S]

You're welcome, James. Sorry I wasn't thinking straight earlier on in the
thread!

--
Echo [MS PPT MVP]
http://www.echosvoice.com

Great information. I really appreciate it.

James