Software

Ask something
Discussion Locked

Import a excel doc. into powerpoint

0 helpful
5 replies

by reynoldss

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have an excel document that is made up of 8 worksheets. There are formulas on some sheets that take values from the other sheets. I need to copy the sheets into powerpoint, and the formulas all still need to work. Powerpoint will let you update all of the formulas apart from the ones that draw data from another sheet. Is there a way to link the slides so that the formulas will draw data from the other slides?

5 replies

by the jedi

If you copy the sheets into another blank excel document using the paste special function & tick copy values only it will copy just the values not the formulas. Then you will have the data to import into powerpoint

by dklippert

Copy the spreadsheet and then Paste Special using the link option. Or use Insert Object from file and choose link. When you double click the sheet, you will open Excel for editing.

This discussion is closed to new replies.