Neil has attended:
Project Management - Framework & Processes course
Powerpoint
How can I embed Excel data from a working model (to update a tab from the spreadsheet) automatically for a periodic report?
RE: Powerpoint
Hi Neil
Thanks for getting in touch. You can get data to update automatically from Excel to PowerPoint by following this process:
Have your spreadsheet and your presentation open at the same time
Highlight the spreadsheet data and Copy it
Go to your slide
Right-click and choose Paste Special
Choose the option Paste Link, and press OK.
Now whenever changes are made and then the presentation is re-opened, it will be up to date. To reflect changes more recent than that, right-click the imported data and choose Update Link.
I hope that helps.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
