Share via

Excel formula does not paste into powerpoint

Anonymous
2012-07-04T22:01:08+00:00

Hopefully a simple question this, however I cannot for the life of me work out how to do it.

This issue is with Office 2010.

I have a cell in Excel which has a formula, the formula is just a sum of several other cells which I use to embed a chart into Powerpoint.

I basically need to also copy this cell complete with the formula into powerpoint. I do a copy in Excel and then paste special in Powerpoint and embed this into Powerpoint, however when I have done this the formula does not work.

Can someone please tell me where I am going wrong?

Thank-you.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2012-07-05T15:04:53+00:00

    In order to copy the excel worksheet with formulas to be retained, you will need to insert the excel worksheet as an object.

    Follow the steps to copy the selected cells with formulas:

    1.       Click on Insert tab -> Click on Object.

    2.       Select Microsoft Excel Worksheet -> Click on OK

    3.       Open the Excel workbook where the data is and copy the desired cells.

    4.       Paste them in the blank Excel workbook in PowerPoint.

    5.       Adjust the Excel workbook in the slide to show only the cells you would like to view.

    6.       Click anywhere in the slide to change the Excel edit mode.

    7.       Double click on the table to edit if required.

    Check if the above steps helps.

    5 people found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest