In order to simulate something for a customer, I want to embed a spreadsheet with various formulas on it, and then create a button in Power Point that can be clicked to open a User Form and update the fields to auto-update the spreadsheet and the simulation.I can get the spreadsheet it was copied from to update, but not the embedded spreadsheet.Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free.You'll be able to ask any tech support questions, or chat with the community and help others.Specific steps: Object method it goes a bit weird and refuses to adjust the size properly.The best way I have found is to highlight the area you are copying in Excel, right click on ppt slide and page embedded object - the icon looks like a little white box in the middle of the paste special options.The question was specifically around a 'live link' (meaning the Excel file exists externally to the Word doc, and controlling the view is a complex problem not solved by any of these answers).Answer: Using the Word Field Code parameters of LINK you can specify a named range as a Viewing Area.
If the excel worksheet is in the "page layout" view (which is what i was using when copying the cells), it always led to extra columns shown when pasting or updating link in ppt.
All I want is a simple way to change figures in Power Point during slideshow mode without having to open another program or edit the slide directly.
We're a friendly computing community, bustling with knowledgeable members to help solve your tech questions.
You must double click the embedded object to edit it in Word.
Cells that reflect what is currently displayed will be selected. Select elsewhere in the main document to stop editing in the embedded object.