Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

importing tables excel

Forum home » Delegate support and help forum » Microsoft Powerpoint Training and help » Importing tables from Excel

Importing tables from Excel

ResolvedVersion 2003

Grant has attended:
PowerPoint Introduction course
Excel Intermediate course

Importing tables from Excel

How can Excel tables be imported with formulas in tact so that when values are changed in Powerpoint, formals are recalculated

RE: Importing tables from Excel

Hi Grant, thanks for your query. If you cut and paste your chart onto a slide, it creates a dynamically linked chart, so if your source data changes the chart should update next time you open the file. Additionally, if you click Insert-Object and browse to the file you can important the Excel table that way. Try this out, change your source data and double check the update is occurring. The link is dynamic, so updates to the data in the embedded chart in Powerpoint should be reflected in the source Excel file but be careful doing it that way as there are some stability issues changing data that way.

Hope this helps,

Anthony

Mon 8 Mar 2010: Automatically marked as resolved.

PowerPoint tip:

Removing formatting quickly in PowerPoint

Want to remove formatting from text in PowerPoint? Select the text and use Ctrl + spacebar to remove formatting.

The selected text is formatted to the font used on the slide master in PowerPoint.

View all PowerPoint hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.