Powerpoint

Resolved · Low Priority · Version 2007

Mon 29 Oct 2012, 15:57 Delegate Neil said...

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?

Tue 30 Oct 2012, 14:13 Trainer Gary said...

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

Tue 6 Nov 2012: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Ms office courses

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Microsoft Office tip:

Prevent macros from running when you start Applications

Macros are automated programs that can help you speed up your work. They can be embedded in caommands like AutoExec which will make them run as soon as an application like MS Word or MS Access are launched.
Sometimes it is useful to be able to switch off this function, and then can be done by the following method.
Hold down the SHIFT key when you click on the icon to start the program. This will suppress any automated macros.

View all Microsoft Office hints and tips