i want my excel links in powerpoint to update whilst playing show

A

AJH

I have copied sections of an Excel spreadsheet into PowerPoint and they
update ok but I want to have it so that the links automatically update whilst
the presentation is showing. How do I do this?
 
B

Brian Reilly, MVP

AJH,
The functionality for this has changed since PPT 97 where it worked
seamlessly if the Excel file was open. It no longer does that so you
would have to resort to VBA to do this during a screenshow. Possibly
the easiest way would be to tie into the worksheet change event to
fire the necessary VBA code to PPT to update the links.

Brian Reilly, MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embed the same Excel multiple times 0
Integrating information from Word to Excel (not mail merge) 1
Linking data in MS Word into Excel 5
automatic copy paste excel chart 0
copy paste excel charts into ppt automatically 0
Auto-Numbering in a Table in MS Word 1
Email notifications without opening application 1
copy paste chart into ppt 0

Top