Microsoft Office How-to: Incorporate a Spreadsheet in PowerPoint
When you need stronger formatting and mathematical capabilities than PowerPoint builds in to its own tables, you can use Excel instead. Move to the slide where you want the table added. Switch to Excel and copy the data range you want to use.
Switch back to PowerPoint and use the Edit/Paste Special command, then choose the "Paste link" radio button. From the "As" box, choose "Microsoft Excel Worksheet Object."
To edit a cell, double-click on the range once to open the cell range in original Excel file. When you are done editing in Excel, use Excel's File/Close command, save the file, then switch back to PowerPoint.
When you need stronger formatting and mathematical capabilities than PowerPoint builds in to its own tables, you can use Excel instead. Move to the slide where you want the table added. Switch to Excel and copy the data range you want to use.
Switch back to PowerPoint and use the Edit/Paste Special command, then choose the "Paste link" radio button. From the "As" box, choose "Microsoft Excel Worksheet Object."
To edit a cell, double-click on the range once to open the cell range in original Excel file. When you are done editing in Excel, use Excel's File/Close command, save the file, then switch back to PowerPoint.
