excel function within a slide

L

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
 
M

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 ?
 
S

Simmon

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.
 
S

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.
 
L

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
 
L

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
 
L

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
 
Top