excel function within a slide

[lynne baker]

Hi chaps
I'm using PPT 2003 and Excel 2003
I'd like to create a table within PPT such that upon entering numerical
values in the cells it calculates the sum which appears in a different
cell.
I assumed that the way to do this was to embed an excel sheet, but this
doesn't work!

Please could anyone advise me?
many thanks
lynne

 

[MJC]

Lynne,

I am running PowerPoint & Excel 2000 and it seems to be working fine
(embedded Excel Worksheet into PPT that has values in a column and in
another cell the sum function responds with the sum of the column cells
- when I change a value in column cell, the summation updates
automatically)

I would expect the same to happen in Excel 2003. Is there something
else you are doing ?

 

[Guest]

lynne,I am using PPT 2003 ,too. and it seems to be working fine. Maybe you
can try again following the steps below:
Insert-->Object-->Microsoft Excel, now you should have an Excel table on
your slide. enter numerical values in the cells, click the cell which you
want your sum locate in. click "fx" in the toolbar, in the select function of
the popup dailog,highlight "sum" and press "OK".
hope this would help.

 

[Steve Rindsberg]

Hi chaps
I'm using PPT 2003 and Excel 2003
I'd like to create a table within PPT such that upon entering numerical
values in the cells it calculates the sum which appears in a different
cell.
I assumed that the way to do this was to embed an excel sheet, but this
doesn't work!

It depends on what you expect of it.

With an embedded Excel sheet, you have to doubleclick the sheet within PPT to
"activate" it ... in effect, open it for editing. Then you can change numbers
and formulas in the cells and they'll recalculate just as though you were doing
the work in Excel.

With a linked Excel sheet, you'd change the data in the original Excel file and
the next time you open the PPT, it'll update automatically. Or you can
doubleclick the Excel sheet in PPT to edit it in Excel, save and get updates.

If that's not happening for you, please explain in more detail what you mean
when you say "doesn't work" ... that covers a lot of ground. We need to know
which particular plot to start digging in.

 

[Shyam Pillai]

To add to Steve's post. If you wish to have a truly interactive spreadsheet
in slide show mode then you need to place a Microsoft Office Spreadsheet
11.0 control on the slide. During slideshow this offers seamless
interactivity.

 

[Steve Rindsberg]

To add to Steve's post. If you wish to have a truly interactive spreadsheet
in slide show mode then you need to place a Microsoft Office Spreadsheet
11.0 control on the slide. During slideshow this offers seamless
interactivity.

Thanks ... I keep forgetting about those fellas.

A few guesses:

This will work if the control is installed on the computer that's running the
presentation but not otherwise.

And not at all in the viewer?

How am I doing against the odds? ;-)

 

[Shyam Pillai]

That is correct.

 

[lynne baker]

Hi guys
many thanks for your replies.
I hadn't realised that i had to double click to "get into" the excel
sheet!
i think it might be ok now - i'll update you as necessary.
thanks again
lynne

 

[lynne baker]

Hi chaps
now that i've got it to work nicely within the slide, please can you
tell me how i get it to stay a certain size?!
It seems to resize itself periodically, and when i finish doing the
calculations withing excel the inserted object becomes a tiny wee
thing, just showing the cell with the totals in it!
I fear I'm doing something wrong, rather than this being a "feature"
many thanks, as always
lynne

 

[Steve Rindsberg]

Hi chaps
now that i've got it to work nicely within the slide, please can you
tell me how i get it to stay a certain size?!
It seems to resize itself periodically, and when i finish doing the
calculations withing excel the inserted object becomes a tiny wee
thing, just showing the cell with the totals in it!
I fear I'm doing something wrong, rather than this being a "feature"

Try linking your Excel content to the slide rather than copy/pasting.

 

[lynne baker]

Thanks Steve for this, but when i link the sheet powerpoint drops into
excel to open it rather than being able to type straight into the
cells.
Any suggestions?!
thanks so much
lynne

 

[Steve Rindsberg]

Thanks Steve for this, but when i link the sheet powerpoint drops into
excel to open it rather than being able to type straight into the
cells.

Is this something you're trying to do during a slide show, or do you just need
to update information?