importing tables excel

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

Importing tables from Excel

resolvedResolved · Low Priority · Version 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.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

PowerPoint tip:

Use a Company logo as a bullet

Once you have a saved picture of your company logo.

1. Format / Bullets and Numbering
2. On the bulleted Tab choose Picture
3. Use import to find you Logo

Once you import a pic it stays there permanately.

View all PowerPoint hints and tips


Server loaded in 0.08 secs.